Scribd
Upload
137 views1 page

Financial Statement Overview

This document is a worksheet containing accounting transaction data for a company. It includes debit and credit amounts for various accounts such as cash, accounts receivable, inventory, equipment, accounts payable, loans, sales, costs of goods sold, expenses, and more. The worksheet shows opening balances, adjustments, closing balances, and calculates net income. In total, it tracks over 3 billion rupiah across dozens of accounts.

Uploaded by

Salsa nabila Raflani putri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
137 views1 page

Financial Statement Overview

This document is a worksheet containing accounting transaction data for a company. It includes debit and credit amounts for various accounts such as cash, accounts receivable, inventory, equipment, accounts payable, loans, sales, costs of goods sold, expenses, and more. The worksheet shows opening balances, adjustments, closing balances, and calculates net income. In total, it tracks over 3 billion rupiah across dozens of accounts.

Uploaded by

Salsa nabila Raflani putri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

WORKSHEET

UD BUANA

NERACA SALDO AJP NSD RUGI LABA NERACA


KODE NAMA AKUN
DEBIT KREDIT DEBIT KREDIT DEBIT KREDIT DEBIT KREDIT DEBIT KREDIT
1-1100 CASH IN BANK Rp 161.170.000,00 Rp 5.070.000,00 Rp 166.240.000,00 Rp 166.240.000,00
1-1200 PETTY CASH Rp 5.275.000,00 Rp 5.275.000,00 Rp 5.275.000,00
1-1300 ACCOUNTS RECEIVABLE Rp 709.500.000,00 Rp 709.500.000,00 Rp 709.500.000,00
1-1400 ALLOWANCE FOR DOUBTFUL DEBT Rp 19.000.000,00 Rp 16.475.000,00 Rp 35.475.000,00 Rp 35.475.000,00
1-1500 MERCHANDISE INVENTORY Rp 617.600.000,00 Rp 617.600.000,00 Rp 617.600.000,00
1-1600 STORE SUPPLIES Rp 10.800.000,00 Rp 5.950.000,00 Rp 4.850.000,00 Rp 4.850.000,00
1-1700 PREPAID INSURANCE Rp 15.300.000,00 Rp 1.250.000,00 Rp 14.050.000,00 Rp 14.050.000,00
1-1800 PREPAID RENT Rp 21.300.000,00 Rp 2.500.000,00 Rp 18.800.000,00 Rp 18.800.000,00
1-1900 PREPAID TAX Rp 15.000.000,00 Rp 15.000.000,00 Rp 15.000.000,00
1-2100 EQUIPMENT AT COST Rp 63.300.000,00 Rp 63.300.000,00 Rp 63.300.000,00
1-2110 EQUIPMET ACCUM DEP Rp 16.500.000,00 Rp 1.250.000,00 Rp 17.750.000,00 Rp 17.750.000,00
2-1100 ACCOUNTS PAYABLE Rp 788.260.000,00 Rp 788.260.000,00 Rp 788.260.000,00
2-1200 EXPENSE PAYABLE Rp 425.000,00 Rp 5.700.000,00 Rp 6.125.000,00 Rp 6.125.000,00
2-1300 INCOME TAX PAYABLE Rp 7.862.500,00 Rp 7.862.500,00 Rp 7.862.500,00
2-1400 PPN PAYABLE Rp 3.540.000,00 Rp 3.540.000,00 Rp 3.540.000,00
2-1500 PPN OUTCOME Rp 101.200.000,00 Rp 101.200.000,00
2-1600 PPN INCOME Rp 97.660.000,00 Rp 97.660.000,00
2-2100 BANK PERMATA LOAN Rp 285.000.000,00 Rp 285.000.000,00 Rp 285.000.000,00
3-1100 RAKA CAPITAL Rp 366.500.000,00 Rp 366.500.000,00 Rp 366.500.000,00
3-1200 RAKA DRAWING Rp 26.400.000,00 Rp 26.400.000,00 Rp 26.400.000,00
4-1100 SALES Rp 1.565.300.000,00 Rp 1.565.300.000,00 Rp 1.565.300.000,00
4-1200 SALES RETURN Rp 50.000.000,00 Rp 50.000.000,00 Rp 50.000.000,00
5-1100 COST OF GOODS SOLD Rp 1.193.100.000,00 Rp 1.193.100.000,00 Rp 1.193.100.000,00
5-1200 FREIGHT PAID Rp 8.800.000,00 Rp 8.800.000,00 Rp 8.800.000,00
6-1000 ADVERTISING EXP Rp 4.950.000,00 Rp 4.950.000,00 Rp 4.950.000,00
6-1100 TELEPHON & ELECRTICITY EXP Rp 8.700.000,00 Rp 2.200.000,00 Rp 10.900.000,00 Rp 10.900.000,00
6-1200 STORE SUPPLIES EXP Rp 4.750.000,00 Rp 5.950.000,00 Rp 10.700.000,00 Rp 10.700.000,00
6-1300 BAD DEBTS EXP Rp 15.100.000,00 Rp 16.475.000,00 Rp 31.575.000,00 Rp 31.575.000,00
6-1400 DEPRECIATION EXP Rp 16.500.000,00 Rp 1.250.000,00 Rp 17.750.000,00 Rp 17.750.000,00
6-1500 INSURANCE EXP Rp 14.300.000,00 Rp 1.250.000,00 Rp 15.550.000,00 Rp 15.550.000,00
6-1600 RENT EXP Rp 23.300.000,00 Rp 2.500.000,00 Rp 25.800.000,00 Rp 25.800.000,00
6-1700 WAGES & SALARIES EXP Rp 36.300.000,00 Rp 3.500.000,00 Rp 39.800.000,00 Rp 39.800.000,00
6-1800 OTHER OPERATING EXP Rp 10.100.000,00 Rp 10.100.000,00 Rp 10.100.000,00
8-1100 INTEREST REVENUE Rp 6.100.000,00 Rp 5.320.000,00 Rp 11.420.000,00 Rp 11.420.000,00
9-1100 INTEREST EXPENSE Rp 12.480.000,00 Rp 12.480.000,00 Rp 12.480.000,00
9-1200 BANK SERVICE CHARGE Rp 6.600.000,00 Rp 250.000,00 Rp 6.850.000,00 Rp 6.850.000,00
9-1300 INCOME TAX EXPENSE Rp 7.862.500,00 Rp 7.862.500,00 Rp 7.862.500,00
JUMLAH Rp 3.148.285.000,00 Rp 3.148.285.000,00 Rp 147.507.500,00 Rp 147.507.500,00 Rp 3.087.232.500,00 Rp 3.087.232.500,00 Rp 1.446.217.500,00 Rp 1.576.720.000,00 Rp 1.641.015.000,00 Rp 1.510.512.500,00
Rp 130.502.500,00 Rp 130.502.500,00
Rp 1.576.720.000,00 Rp 1.576.720.000,00 Rp 1.510.512.500,00 Rp 1.510.512.500,00

You might also like