Scribd
Upload
11 views19 pages

Monthly Financial Transactions Summary

The document outlines financial transactions for a business over the month of September, detailing debits and credits for various accounts including cash, accounts receivable, expenses, and revenues. It includes adjustments for depreciation and closing entries, resulting in a net profit of 73,916.67 and total assets of 341,616.67. Additionally, it provides an overview of the income statement and balance sheet, summarizing the financial position of the business at the end of the period.

Uploaded by

noriga.francinefaye.dll
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views19 pages

Monthly Financial Transactions Summary

The document outlines financial transactions for a business over the month of September, detailing debits and credits for various accounts including cash, accounts receivable, expenses, and revenues. It includes adjustments for depreciation and closing entries, resulting in a net profit of 73,916.67 and total assets of 341,616.67. Additionally, it provides an overview of the income statement and balance sheet, summarizing the financial position of the business at the end of the period.

Uploaded by

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

Date Particulars Debit

1-Sep Cash 250,000.00


Reyes, Capital
#
Office Equipment 10,000.00
Cash
#
Internet Expense 3,000.00
Cash
#
5-Sep A/R 25,000.00
Service Revenue
(Samantha Cruz)
Domain Name Expense 800.00
Cash
#
10-Sep Cash 15,000.00
Service Revenue
#
Utilities Expenses 500.00
Cash
#
Office Supplies Expense 1,500.00
A/P
{Office Supplies Depot)
15-Sep A/R 30,000.00
Service Revenue
(Luisa Gomez)
#
Mobile Phone Expense 350.00
Cash
#
A/P 800.00
Cash
{Office Supplies Depot)
#
20-Sep Cash 25,000.00
A/R
(Samantha Cruz)
#
Office Supplies Expense 600.00
Cash
#
Salaries Expense 5,000.00
Accrued Salaries
#
Office Furniture 5,000.00
A/P
{Furniture World }
#
25-Sep A/R 20,000.00
Service Revenue
(Michael Lee)
#
Professional Development Expense 1,500.00
Cash
#
Rent Expense 5,400.00
Cash
#
Computer Equipment 20,000.00
A/P
{Tech Depot }
#
30-Sep Cash 30,000.00
A/R
(Luisa Gomez)
#
Accrued Salaries 5,000.00
Cash
#
Reyes, Capital 8,000.00
Cash
#
Taxes and Licenses 2,700.00
Cash

ADJUSTMENTS
30-Sep Depreciation Expense 133.33
Accumulated Depreciation
#
Prepaid Rent 5,400.00
Rent Expense

CLOSING
30-Sep Income Summary 16,083.33
Utilities Expense
Salaries Expense
Office Supplies Expense
Internet Expense
Domain Name Expense
Mobile Phone Expense
Professional Development Expense
Depreciation Expense
Taxes and Licenses
#
Service Revenue 90,000.00
Income Summary
#
Income Summary 73,916.67
Reyes, Capital
Credit Cash
1-Sep 250,000.00 10,000.00 1-Sep
250,000.00 10-Sep 15,000.00 3,000.00 1-Sep
20-Sep 25,000.00 800.00 5-Sep
30-Sep 30,000.00 500.00 10-Sep
10,000.00 350.00 15-Sep
800.00 15-Sep
600.00 20-Sep
3,000.00 1,500.00 25-Sep
5,400.00 25-Sep
5,000.00 30-Sep
25,000.00 8,000.00 30-Sep
2,700.00 30-Sep
320,000.00 38,650.00
800.00 281,350.00 Balance
320,000.00 320,000.00

15,000.00
A/R
5-Sep 25,000.00 25,000.00 20-Sep
500.00 15-Sep 30,000.00 30,000.00 30-Sep
25-Sep 20,000.00
75,000.00 55,000.00
1,500.00 20,000.00 Balance
75,000.00 75,000.00

30,000.00
Prepaid Rent
30-Sep 5,400.00
5,400.00 -
350.00 5,400.00 Balance
5,400.00 5,400.00

800.00
Office Equipment
1-Sep 10,000.00
10,000.00 -
25,000.00 10,000.00 Balance
10,000.00 10,000.00

600.00 Office Furniture


20-Sep 5,000.00
5,000.00 -
5,000.00 5,000.00 Balance
5,000.00 5,000.00

5,000.00
Computer Equipment
25-Sep 20,000.00
20,000.00 -
20,000.00 20,000.00 Balance
20,000.00 20,000.00

1,500.00 Accumulated Depreciation


133.33 30-Sep
- 133.33
5,400.00 Balance 133.33
133.33 133.33

20,000.00
A/P
15-Sep 800.00 1,500.00 10-Sep
5,000.00 20-Sep
30,000.00 20,000.00 25-Sep
800.00 26,500.00
Balance 25,700.00
26,500.00 26,500.00
5,000.00

Accrued Salaries
8,000.00 30-Sep 5,000.00 5,000.00 20-Sep
5,000.00 5,000.00
Balance -
2,700.00 5,000.00 5,000.00

Reyes, Capital
133.33 30-Sep 8,000.00 250,000.00 1-Sep
8,000.00 250,000.00
Balance 242,000.00
5,400.00 250,000.00 250,000.00

Service Revenue
500.00 25,000.00 5-Sep
5,000.00 15,000.00 10-Sep
2,100.00 30,000.00 15-Sep
3,000.00 20,000.00 25-Sep
800.00 - 90,000.00
350.00 Balance 90,000.00
1,500.00 90,000.00 90,000.00
133.33
2,700.00
Rent Expense
25-Sep 5,400.00 5,400.00 30-Sep
115,000.00 5,400.00 5,400.00
- Balance
5,400.00 5,400.00
98,766.67

Utilities Expense
10-Sep 500.00
500.00 -
500.00 Balance
500.00 500.00

Salaries Expense
20-Sep 5,000.00
5,000.00 -
5,000.00 Balance
5,000.00 5,000.00

Office Supplies Expense


10-Sep 1,500.00
20-Sep 600.00
2,100.00 -
2,100.00 Balance
2,100.00 2,100.00

Internet Expense
1-Sep 3,000.00
3,000.00 -
3,000.00 Balance
3,000.00 3,000.00

Domain Name Expense


5-Sep 800.00
800.00 -
800.00 Balance
800.00 800.00

Mobile Phone Expense


15-Sep 350.00
350.00 -
350.00 Balance
350.00 350.00

Professional Development Expense


25-Sep 1,500.00
1,500.00 -
1,500.00 Balance
1,500.00 1,500.00

Depreciation Expense
30-Sep 133.33
133.33 -
133.33 Balance
133.33 133.33

Taxes and Licenses


30-Sep 2,700.00
2,700.00 -
2,700.00 Balance
2,700.00 2,700.00
Unadjusted Balance Adjustments
Account Title
Debit Credit Debit
Cash 281,350.00
A/R 20,000.00
Prepaid Rent - 5,400.00
Office Equipment 10,000.00
Accumulated Depreciation -
Office Furniture 5,000.00
Computer Equipment 20,000.00
A/P 25,700.00
Accrued Salaries -
Reyes, Capital 242,000.00
Service Revenue 90,000.00
Rent Expense 5,400.00
Utilities Expense 500.00
Salaries Expense 5,000.00
Office Supplies Expense 2,100.00
Internet Expense 3,000.00
Domain Name Expense 800.00
Mobile Phone Expense 350.00
Professional Development Expense 1,500.00
Depreciation Expense - 133.33
Taxes and Licenses 2,700.00
Total 357,700.00 357,700.00 5,533.33
-
Adjustments Adjusted Balance INCOME STATEMENT
Credit Debit Credit Service Revenue
281,350.00 Less:
20,000.00
5,400.00
10,000.00
133.33 133.33
5,000.00
20,000.00
25,700.00
-
242,000.00 Net Profit
90,000.00
5,400.00 -
500.00
5,000.00
2,100.00
3,000.00
800.00
350.00
1,500.00
133.33
2,700.00
5,533.33 357,833.33 357,833.33
- -
INCOME STATEMENT B
Service Revenue 90,000.00 ASSETS
Utilities Expense 500.00
Salaries Expense 5,000.00
Office Supplies Expense 2,100.00
Internet Expense 3,000.00
Domain Name Expense 800.00
Mobile Phone Expense 350.00
Professional Development Expense 1,500.00
Depreciation Expense 133.33
Taxes and Licenses 2,700.00 16,083.33
Net Profit 73,916.67

TOTAL ASSETS

LIABILITIES & EQUITY

TOTAL LIABILITIES & EQU


BALANCE SHEET
ASSETS
CURRENT ASSETS
Cash 281,350.00
A/R 20,000.00
Prepaid Rent 5,400.00
TOTAL CURRENT ASSETS 306,750.00
NON-CURRENT ASSETS
Office Equipment 10,000.00
Accumulated Depreciation 133.33 9,866.67
Office Furniture 5,000.00
Computer Equipment 20,000.00
TOTAL NON-CURRENT ASSETS 34,866.67
TOTAL ASSETS 341,616.67

LIABILITIES & EQUITY


CURRENT LIABILITIES
A/P 25,700.00
TOTAL CURRENT LIABILITIES 25,700.00
EQUITY
Reyes, Capital 315,916.67
TOTAL EQUITY 315,916.67
TOTAL LIABILITIES & EQUITY 341,616.67
-
Date Particulars Debit Credit
1-Oct A/R 35,000.00
Service Revenue 35,000.00
(Maria Santos)
#
Internet Expense 3,000.00
Cash 3,000.00
#
5-Oct Cash 20,000.00
A/R 20,000.00
(Michael Lee)
#
Domain Name Expense 800.00
Cash 800.00
#
10-Oct A/R 30,000.00
Service Revenue 30,000.00
(Evelyn Tan)
#
Utilities Expenses 500.00
Cash 500.00
#
Office Supplies Expense 2,000.00
A/P 2,000.00
{Office Supplies Depot)
#
15-Oct Cash 35,000.00
A/R 35,000.00
(Maria Santos)
#
Mobile Phone Expense 350.00
Cash 350.00
#
A/P 1,200.00
Cash 1,200.00
{Office Supplies Depot)
#
A/P 3,000.00
Cash 3,000.00
{Furniture World }
#
20-Oct A/R 25,000.00
Service Revenue 25,000.00
(Ben Lim)
#
Office Supplies Expense 600.00
Cash 600.00
#
Salaries Expense 5,000.00
Accrued Salaries 5,000.00
#
25-Oct Cash 30,000.00
A/R 30,000.00
(Evelyn Tan)
#
Subscription Expense 1,200.00
Cash 1,200.00
#
A/P 10,000.00
Cash 10,000.00
{Tech Depot }
#
Taxes and Licenses 2,700.00
Cash 2,700.00
#
30-Oct Accrued Salaries 5,000.00
Cash 5,000.00
#
Reyes, Capital 5,000.00
Cash 5,000.00
#
Utilities Expenses 300.00
Accrued Utilities 300.00

ADJUSTMENTS
30-Oct Depreciation Expense 133.33
Accumulated Depreciation 133.33
#
Rent Expense 1,800.00
Prepaid Rent 1,800.00
Cash
Beg. Bal. 281,350.00 3,000.00 1-Oct
5-Oct 20,000.00 800.00 5-Oct
15-Oct 35,000.00 500.00 10-Oct
25-Oct 30,000.00 350.00 15-Oct
1,200.00 15-Oct
3,000.00 15-Oct
600.00 20-Oct
1,200.00 25-Oct
10,000.00 25-Oct
2,700.00 25-Oct
5,000.00 30-Oct
5,000.00 30-Oct
366,350.00 33,350.00
333,000.00 Balance
366,350.00 366,350.00

A/R
Beg. Bal. 20,000.00 20,000.00 5-Oct
1-Oct 35,000.00 35,000.00 15-Oct
10-Oct 30,000.00 30,000.00 25-Oct
20-Oct 25,000.00
110,000.00 85,000.00
25,000.00 Balance
110,000.00 110,000.00

Prepaid Rent
Beg. Bal. 5,400.00 1,800.00 30-Oct
5,400.00 1,800.00
3,600.00 Balance
5,400.00 5,400.00

Office Equipment
Beg. Bal. 10,000.00
10,000.00 -
10,000.00 Balance
10,000.00 10,000.00

Office Furniture
Beg. Bal. 5,000.00
5,000.00 -
5,000.00 Balance
5,000.00 5,000.00

Computer Equipment
Beg. Bal. 20,000.00
20,000.00 -
20,000.00 Balance
20,000.00 20,000.00

Accumulated Depreciation
133.33 Beg. Bal.
133.33 30-Oct
- 266.67
Balance 266.67
266.67 266.67

A/P
15-Oct 1,200.00 25,700.00 Beg. Bal.
15-Oct 3,000.00 2,000.00 10-Oct
25-Oct 10,000.00
14,200.00 27,700.00
Balance 13,500.00
27,700.00 27,700.00

Accrued Salaries
30-Oct 5,000.00 5,000.00 20-Oct
5,000.00 5,000.00
Balance -
5,000.00 5,000.00

Accrued Utilities
300.00 30-Oct
- 300.00
Balance 300.00
300.00 300.00

Reyes, Capital
30-Oct 5,000.00 315,916.67 Beg. Bal.
5,000.00 315,916.67
Balance 310,916.67
315,916.67 315,916.67

Service Revenue
35,000.00 1-Oct
30,000.00 10-Oct
25,000.00 20-Oct
- 90,000.00
Balance 90,000.00
90,000.00 90,000.00

Rent Expense
30-Oct 1,800.00
1,800.00 -
1,800.00 Balance
1,800.00 1,800.00

Utilities Expense
10-Oct 500.00
30-Oct 300.00
800.00 -
800.00 Balance
800.00 800.00

Salaries Expense
20-Oct 5,000.00
5,000.00 -
5,000.00 Balance
5,000.00 5,000.00

Office Supplies Expense


10-Oct 2,000.00
20-Oct 600.00
2,600.00 -
2,600.00 Balance
2,600.00 2,600.00

Internet Expense
1-Oct 3,000.00
3,000.00 -
3,000.00 Balance
3,000.00 3,000.00

Domain Name Expense


5-Oct 800.00
800.00 -
800.00 Balance
800.00 800.00

Mobile Phone Expense


15-Oct 350.00
350.00 -
350.00 Balance
350.00 350.00

Subscription Expense
25-Oct 1,200.00
1,200.00 -
1,200.00 Balance
1,200.00 1,200.00

Depreciation Expense
30-Oct 133.33
133.33 -
133.33 Balance
133.33 133.33

Taxes and Licenses


30-Sep 2,700.00
2,700.00 -
2,700.00 Balance
2,700.00 2,700.00
Unadjusted Balance Adjustments
Account Title
Debit Credit Debit Credit
Cash 333,000.00
A/R 25,000.00
Prepaid Rent 5,400.00 1,800.00
Office Equipment 10,000.00
Accumulated Depreciation 133.33 133.33
Office Furniture 5,000.00
Computer Equipment 20,000.00
A/P 13,500.00
Accrued Salaries -
Accrued Utilities 300.00
Reyes, Capital 310,916.67
Service Revenue 90,000.00
Rent Expense - 1,800.00
Utilities Expense 800.00
Salaries Expense 5,000.00
Office Supplies Expense 2,600.00
Internet Expense 3,000.00
Domain Name Expense 800.00
Mobile Phone Expense 350.00
Subscription Expense 1,200.00
Depreciation Expense - 133.33
Taxes and Licenses 2,700.00
Total 414,850.00 414,850.00 1,933.33 1,933.33
- -
Adjusted Balance
Debit Credit
333,000.00
25,000.00
3,600.00
10,000.00
266.67
5,000.00
20,000.00
13,500.00
-
300.00
310,916.67
90,000.00
1,800.00
800.00
5,000.00
2,600.00
3,000.00
800.00
350.00
1,200.00
133.33
2,700.00
414,983.33 414,983.33
-

You might also like