Income Statement

0

Fitur ini digunakan oleh user untuk me-review dan mengecek income setiap bisnis. User dapat men-download file report berupa excel dan mencetak report income statement.

15.6.1. Menu Awal Income Statement

Tampilan Gambar XX – Income Statement ini bisa diakses melalui Finance -> Finance Report -> Income Statement.

Gambar XX – Income Statement

Berikut penjelasan lebih lanjut mengenai fungsi dari tombol yang ada pada Tampilan Income Statement.

Tombol Excel, digunakan untuk mengunduh data dalam bentuk file excel berformat .xls klik pada file maka data akan tampil pada excel.

Kolom Periode, digunakan untuk memilih tanggal dan bulan.

Field Nama Branch, digunakan untuk memilih nama Branch Cabang atau HO.

Field Tipe Bisnis, digunakan untuk memilih tipe bisnis yang akan tampil pada file excel.

15.6.2. Download Excel

Berikut ntuk menampilkan data Income Statement:

  1. User terlebih dahulu menginputkan data pada kolom yang tersedia sesuai dengan kriteria data yang akan ditampilkan.
  2. Pilih tombol Excel maka data yang dicari akan terunduh dalam bentuk file excel berformat .xls.
  3. Kemudian klik pada file maka data akan muncul seperti pada tampilan Gambar XX – Report Income Statement.

Gambar XX – Report Income Statement – Unit.

Keterangan:

  1. Net Sales & Revenue:

a. Unit : Total Penjualan -Total Diskon

aa. Penjualan : Unit 3rd  Party

ab. Penjualan : Unit AfCo

ac. Penjualan : Aksesoris 3rd Party

ad. Penjualan : Aksesoris AfCo

ae. Penjualan : Karosesi 3rd Party

af. Penjualan : Karoseri AfCo

ag. Penjualan : Ekspedisi 3rd Party

ah. Penjualan : Ekspedisi AfCo

ai. Penjualan : Pengurusan Dokumen 3rd Party

aj. Penjualan : Pengurusan Dokumen AfCo

ak. Diskon Penjualan : Unit 3rd Party

al. Diskon Penjualan : Unit AfCo

am. Diskon Penjualan : Aksesorios 3rd Party

an. Diskon Penjualan : Aksesoris AfCo

2. Total Net Sales & Revenue : Total Penjualan – Total Diskon

a. Cost of Sales & Revenue

aa. Unit : Total COGS

  • COGS : Unit
  • COGS : PPV Unit
  • COGS : Unit WIP
  • COGS : Aksesoris
  • COGS : PPV Aksesoris
  • COGS : Karoseri
  • COGS : PPV Karoseri
  • COGS : Ekspedisi
  • COGS : PPV Ekspedisi
  • COGS : Pengurusan Dokumen
  • COGS : PPV Pengurusan Dokumen

3. Total Cost of Sales & Revenue : Total COGS

a. Gross Profit

aa. Unit : Total Penjualan – Total Diskon – Total COGS

4. Total Gross Profit : Total Penjualan – Total Diskon – Total COGS

a. Operating Expense : Total Operating Expenses

aa. OPEX : Komisi

ab. OPEX : Subsidi CG

ac. OPEX : Subsidi Rate

ad. Biaya : General Transaction

ae. Biaya : Gaji

af. Biaya : Listrik

ag. Biaya : Promosi

ah. Biaya : Bank

ai. Biaya : Bunga DF Unit

aj. Biaya : Credit Card

ak. Biaya : Pajak Bank

5. Operating Profit : Total Penjualan – Total Diskon – Total COGS – Total Operating Expenses.

a. Interest Income : Total Interest Income

aa. Other Income : Bunga Bank

ab. Interest Expenses : Total Interest Expenses

6. Profit After Interest : Total Penjualan – Total Diskon – Total COGS – Total Operating Expenses + TotalInterest Income – Total Interest Expenses

a. Other Income : Total Other Income

aa. Other Income

ab. Other Income : Selisih

ac. Other Income : Refund

b. Other Expenses

7. Profit Before Tax : Total Penjualan – Total Diskon – Total COGS – Total Operating Expenses + Total Interest Income – Total Interest Expenses + Total Other Income – Total Other Expenses.

8. GP unit : Total Penjualan – Total Diskon – Total COGS – Total Operating Expenses + Total Interest Income – Total Interest Expenses + Total Other Income – Total Other Expenses.

Gambar XX – Report Income Statement – Service & Parts

Keterangan:

  1. Net Sales & Revenue:

a. Service GR : Total Penjualan – Total Diskon

aa. Penjualan : Service 3rd Party

ab. Penjualan : Service AfCo

ac. Penjualan : Parts Sales 3rd Party

ad. Penjualan : Parts Through Service 3rd Party

ae. Penjualan : Parts Sales AfCo

af. Penjualan : Parts Through Service AfCo

ag. Penjualan : Bahan Sales 3rd Party

ah. Penjualan : Bahan Through Service 3rd Party

ai. Penjualan : Bahan Sales AfCo

aj. Penjualan : Bahan Through Service AfCo

ak. Diskon Penjualan : Parts Sales 3rd Party

al. Diskon Penjualan : Parts Through Service 3rd Party

am. Diskon Penjualan : Parts Sales AfCo

an. Diskon Penjualan : Parts Through Service AfCo

ao. Diskon Penjualan : Bahan Sales 3rd Party

ap. Diskon Penjualan : Bahan Through Service 3rd Party

aq. Diskon Penjualan : Bahan Sales AfCo

ar. Diskon Penjualan : Bahan Through Service AfCo

2. Total Net Sales & Revenue : Total Penjualan – Total Diskon

a. Cost of Sales & Revenue : Total COGS

aa. Service GR

  • COGS : Service
  • COGS : Service WIP
  • COGS : Parts Sales
  • COGS : Parts Through Service
  • COGS : PPV Parts
  • COGS : Adjustment Parts Sales
  • COGS : Bahan Sales
  • COGS : Bahan Through Service
  • COGS : PPV Bahan
  • COGS : Adjustment Bahan Sales
  • COGS : PPV OPB
  • COGS : PPV OPL

3. Total Cost of Sales & Revenue : Total COGS

a. Gross Profit

aa. Service GR : Total Penjualan GR – Total Diskon GR – Total COGS GR

4. Total Gross Profit : Total Penjualan – Total Diskon – Total COGS

a. Operating Expense : Total Operating Expenses

aa. Biaya : General Transaction

ab. Biaya : Gaji

ac. Biaya : Listrik

ad. Biaya : Promis

ae. Biaya : Bank

af. Biaya : Bungan DF Parts

ag. Biaya : Credit Card

ah. Biaya : Pajak Bank

5. Operating Profit : Total Penjualan – Total Diskon – Total COGS – Total Operating Expenses.

a. Interest Income : Total Interest Income

aa. Other Income : Bunga Bank

b. Interest Expense : Total Interest Expenses

6. Profit After Interest : Total Penjualan – Total Diskon – Total COGS – Total Operating Expenses + TotalInterest Income – Total Interest Expenses.

a. Other Income : Total Other Income

aa. Other Income

ab. Other Income : Selisih

ac. Other Income : Refund

b. Other Expense : Total Other Expenses

ba. Other Expenses

7. Profit Before Tax : Total Penjualan – Total Diskon – Total COGS – Total Operating Expenses + Total Interest Income – Total Interest Expenses + Total Other Income – Total Other Expenses.

8. GP Service GR : Total Penjualan – Total Diskon – Total COGS – Total Operating Expenses + Total Interest Income – Total Interest Expenses + Total Other Income – Total Other Expenses.