Accounting Financial Analysis Report: July Data and Analysis

This comprehensive accounting financial analysis report presents a detailed overview of a company's financial performance. The report includes a general journal, which meticulously records all financial transactions, and a general ledger, which organizes these transactions by account. An adjusted trial balance ensures the accuracy of the accounting equation, followed by key financial statements. The income statement reveals the company's profitability, the statement of changes in equity tracks changes in owner's equity, and the balance sheet provides a snapshot of the company's assets, liabilities, and equity. The report covers July's financial activities, providing insights into revenue, expenses, and overall financial health, and also includes inventory analysis and depreciation calculations. The report is designed to provide a clear and concise understanding of the company's financial position.

Running head: ACCOUNTING FINANCIAL ANALYSIS REPORT
Accounting Financial Analysis Report
Name of the Student:
Name of the University:
Author’s Note:

1ACCOUNTING FINANCIAL ANALYSIS REPORT
Table of Contents
General Journal:...............................................................................................................................2
General Ledger:...............................................................................................................................6
Adjusted Trial Balance:.................................................................................................................19
Income Statement:.........................................................................................................................20
Statement of Change in Equity:.....................................................................................................22
Balance Sheet:...............................................................................................................................22
Bibliography:.................................................................................................................................24

2ACCOUNTING FINANCIAL ANALYSIS REPORT
General Journal:
General Journal
Post.
Date Account Ref. Debit Credit
1/7/2017 Prepaid Rent A/c. $6,000
GST Clearing A/c. $600
Cash at Bank A/c. $6,600
2/7/2017 Cash at Bank A/c. $12,160
Discount Allowed A/c. $582
GST Clearing A/c. $58
Accounts Receivable-
Musical Maestro A/c.
$12,800
6/7/2017
Inventory- Children
Acoustic A/c. $3,782
GST Clearing A/c. $378
Accounts Payable- Unique
Guitars A/c.
$4,160
8/7/2017 Loan Interest Payable A/c. $109
Cash at Bank A/c. $109
9/7/2017 Accounts Payable- Kids
Music A/c.
$6,000
Cash at Bank A/c. $5,820
Discount Received A/c. $164
GST Clearing A/c. $16
10/7/2017 Accounts Receivable-
Village Guitars A/c.
$8,200
Sales Revenue A/c. $7,455
GST Clearing A/c. $745
10/7/2017 Cost of Goods Sold A/c. $5,819
Inventory-Children's
Acoustic A/c.
$5,819

3ACCOUNTING FINANCIAL ANALYSIS REPORT
11/7/2017 Cash at Bank A/c. $5,000
Sales Revenue A/c. $4,545
GST Clearing A/c. $455
11/7/2017 Cost of Goods Sold A/c. $3,200
Inventory-Jazz Bass A/c. $3,200
13/7/2017 Cash at Bank A/c. $12,600
Accounts Receivable-
Electric Heaven A/c.
$12,600
13/7/2017 Sales Return & Allowances
A/c.
$909
GST Clearing A/c. $91
Accounts Receivable-
Village Guitars A/c.
$1,000
13/7/2017 Inventory Write Down
Expense A/c.
$640
Cost of Goods Sold A/c. $640
14/7/2017 Accounts payable A/c.-
Custom Guitars A/c.
$5,340
Cash at Bank A/c. $5,340
15/7/2017 Cash at Bank A/c. $7,200
Accounts Receivable-
Guitar Zone A/c. $7,200
16/7/2017 Equipment Repairs A/c. $100
GST Clearing A/c. $10
Cash at Bank A/c. $110
17/7/2017 Electricity Payable A/c. $150
Cash at Bank A/c. $150
17/7/2017 Telephone Payable A/c. $375
Cash at Bank A/c. $375
18/7/2017 Inventory- Adult Acoustic
A/c.
$1,680
Inventory- Flamenco A/c. $2,500
GST Clearing A/c. $418

4ACCOUNTING FINANCIAL ANALYSIS REPORT
Accounts Payable - Guitar
World A/c.
$4,598
19/7/2017 Accounts Receivable- Hard
Rock Guitars A/c.
$5,460
Sales Revenue A/c. $4,964
GST Clearing A/c. $496
19/7/2017 Cost of Goods Sold A/c. $4,550
Inventory- Standard
Fenders A/c.
$4,550
21/7/2017 Drawings A/c. $500
Cash at Bank A/c. $500
25/7/2017 Accountant Fees A/c. $300
Cleaning Charges A/c. $200
GST Clearing A/c. $50
Cash at Bank A/c. $550
31/7/2017 Wages A/c. $4,000
Cash at Bank A/c. $3,600
PAYG Payable A/c. $400
31/7/2017 Office Supplies Expense A/c. $336
Office Supplies A/c. $336
Depreciation Expense-
Equipment A/c. $75
Accumulated Depreciation-
Equipment A/c. $75
Depreciation Expense- Motor
Vehicle A/c. $417
Accumulated Depreciation-
Motor Vehicle A/c. $417
Depreciation Expense- Fixtures
A/c. $123
Accumulated Depreciation-
Furniture & Fixtures A/c. $123
Wages Expense A/c. $133

5ACCOUNTING FINANCIAL ANALYSIS REPORT
Wages Payable A/c. $133
Telephone Expenses A/c. $168
Electricity Expenses A/c. $353
GST Clearing A/c. $52
Telephone Payable A/c. $185
Electricity Payable A/c. $388
Loan Interest Expense A/c. $109
Loan Interest payable A/c. $109
Bank Fees A/c. $25
Cash at Bank A/c. $25
Bad Debt Expenses A/c. $3,500
Accounts Receivable- The
Instrument Learning Place A/c. $3,500
Inventory Gain/Loss A/c. $1,811
Inventory- Children Acoustic
A/c. $291
Inventory- Hollow Body Centre
A/c. $520
Inventory- Flamneco A/c. $1,000
Insurance A/c. $200
Prepaid Insurance A/c. $200
Advertising A/c. $400
Prepaid Advertising A/c. $400
Rent A/c. $2,000
Prepaid Rent A/c. $2,000
Profit & Loss Summary A/c. $29,310
Sales Return & Allowances $909
Cost of Goods Sold $12,929
Inventor Write Down Expense $640
Discount Allowed $582
Inventory Gain/Loss $1,811
Equipment Repairs $100
Accounting Fees $300
Advertising Expense $400

6ACCOUNTING FINANCIAL ANALYSIS REPORT
Bank Fees $25
Depreciation Expense $614
Electricity Expense $353
Insurance $200
Office Supplies Expense $336
Rent Expense $2,000
Telephone Expense $168
Wages Expense $4,133
Cleaning Charges $200
Loan Interest Expense $109
Bad Debt Expense $3,500
Sales Revenue $16,964
Discount Received $164
Capital - Jason Fender $12,182
Profit & Loss Summary A/c. $29,310
General Ledger:
General Ledger
CASH AT BANK 100
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $48,556 Dr.
Prepaid Rent A/c. $6,000 $42,556 Dr.
GST Clearing A/c. $600 $41,956 Dr.
2-Jul Accounts Receivable-
Musical Maestro A/c.
$12,160 $54,116
Dr.
8-Jul Loan Interest Payable
A/c.
$109 $54,007
Dr.
9-Jul Accounts Payable-
Kids Music A/c.
$5,820 $48,187
Dr.
11-Jul Sales Revenue A/c. $4,545 $52,732 Dr.
GST Clearing A/c. $455 $53,187 Dr.
13-Jul Accounts Receivable-
Electric Heaven A/c.
$12,600 $65,787
Dr.
14-Jul Accounts payable A/c.-
Custom Guitars A/c.
$5,340 $60,447
Dr.
15-Jul Accounts Receivable-
Guitar Zone A/c.
$7,200 $67,647
Dr.

7ACCOUNTING FINANCIAL ANALYSIS REPORT
16-Jul Equipment Repairs
A/c.
$100 $67,547
Dr.
GST Clearing A/c. $10 $67,537 Dr.
17-Jul Electricity Payable A/c. $150 $67,387 Dr.
17-Jul Telephone Payable
A/c.
$375 $67,012
Dr.
21-Jul Drawings A/c. $500 $66,512 Dr.
25-Jul Accountant Fees A/c. $300 $66,212 Dr.
Cleaning Charges A/c. $200 $66,012 Dr.
GST Clearing A/c. $50 $65,962 Dr.
31-Jul Wages A/c. $3,600 $62,362 Dr.
31-Jul Bank Fees A/c. $25 $62,337 Dr.
$62,337 Dr.
$62,337 Dr.
$62,337 Dr.
$62,337 Dr.
$62,337 Dr.
OFFICE SUPPLIES ON HAND 101
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $1,317 Dr.
31-Jul Office Supplies
Expense A/c.
$336 $981
Dr.
$981 Dr.
$981 Dr.
ACCOUNTS RECEIVABLE CONTROL 102
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $47,600 Dr.
2-Jul Cash at Bank A/c. $12,160 $35,440 Dr.
Discount Allowed A/c. $582 $34,858 Dr.
GST Clearing A/c. $58 $34,800 Dr.
10-Jul Sales Revenue A/c. $7,455 $42,255 Dr.
GST Clearing A/c. $745 $43,000 Dr.
13-Jul Cash at Bank A/c. $12,600 $30,400 Dr.
13-Jul Sales Return &
Allowances A/c.
$909 $29,491
Dr.
GST Clearing A/c. $91 $29,400 Dr.
15-Jul Cash at Bank A/c. $7,200 $22,200 Dr.
19-Jul Sales Revenue A/c. $4,964 $27,164 Dr.
GST Clearing A/c. $496 $27,660 Dr.

8ACCOUNTING FINANCIAL ANALYSIS REPORT
31-Jul Bad Debt Expenses
A/c.
$3,500 $24,160
Dr.
$24,160 Dr.
$24,160 Dr.
$24,160 Dr.
$24,160 Dr.
INVENTORY 112
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $46,400 Dr.
6-Jul Accounts Payable-
Unique Guitars A/c.
$3,782 $50,182
Dr.
10-Jul Cost of Goods Sold
A/c.
$5,819 $44,363
Dr.
11-Jul Cost of Goods Sold
A/c.
$3,200 $41,163
Dr.
18-Jul Accounts Payable -
Guitar World A/c.
$4,180 $45,343
Dr.
19-Jul Cost of Goods Sold
A/c.
$4,550 $40,793
Dr.
31-Jul Inventory Gain/Loss
A/c.
$1,811 $38,982
Dr.
$38,982 Dr.
$38,982 Dr.
PREPAID ADVERTISING 104
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $1,600 Dr.
31-Jul Advertising A/c. $400 $1,200 Dr.
$1,200 Dr.
$1,200 Dr.
$1,200 Dr.
PREPAID INSURANCE 106
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $2,400 Dr.
31-Jul Insurance A/c. $200 $2,200 Dr.
$2,200 Dr.
$2,200 Dr.
$2,200 Dr.

9ACCOUNTING FINANCIAL ANALYSIS REPORT
PREPAID RENT 107
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Cash at Bank A/c. $6,000 $6,000 Dr.
31-Jul Rent A/c. $2,000 $4,000 Dr.
$4,000 Dr.
$4,000 Dr.
$4,000 Dr.
$4,000 Dr.
$4,000 Dr.
FURNITURE AND FIXTURES – AT COST 160
Post.
Date Explanation Ref. Debit Credit Balance
7-Jan Balance $4,908 Dr.
$4,908 Dr.
$4,908 Dr.
$4,908 Dr.
$4,908 Dr.
ACCUMULATED DEPRECIATION – FURNITURE
AND FIXTURES 161
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $982 Cr.
31-Jul Depreciation Expense-
Fixtures A/c.
$123 $1,105
Cr.
$1,105 Cr.
$1,105 Cr.
OFFICE EQUIPMENT - AT COST 170
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $3,335 Dr.
$3,335 Dr.
$3,335 Dr.

10ACCOUNTING FINANCIAL ANALYSIS REPORT
$3,335 Dr.
$3,335 Dr.
ACCUMULATED DEPRECIATION – OFFICE
EQUIPMENT 171
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $1,334 Cr.
31-Jul Depreciation Expense-
Equipment A/c.
$75 $1,409
Cr.
$1,409 Cr.
$1,409 Cr.
$1,409 Cr.
$1,409 Cr.
MOTOR VEHICLES – AT COST 180
Post.
Date Explanation Ref. Debit Credit Balan
ce
1-Jul Balance 25,000
25,000
25,000
25,000
25,000
25,000
ACCUMULATED DEPRECIATION – MOTOR
VEHICLES 181
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $9,984 Cr.
31-Jul Depreciation Expense-
Motor Vehicle A/c.
$417 $10,401
Cr.
$10,401 Cr.
$10,401 Cr.
$10,401 Cr.
$10,401 Cr.
$10,401 Cr.

11ACCOUNTING FINANCIAL ANALYSIS REPORT
ACCOUNTS PAYABLE CONTROL 200
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $43,400 Cr.
6-Jul Inventory- Children
Acoustic A/c.
$3,782 $47,182
Cr.
GST Clearing A/c. $378 $47,560 Cr.
9-Jul Cash at Bank A/c. $5,820 $41,740 Cr.
Discount Received
A/c.
$164 $41,576
Cr.
GST Clearing A/c. $16 $41,560 Cr.
14-Jul Cash at Bank A/c. $5,340 $36,220 Cr.
18-Jul Inventory- Adult
Acoustic A/c.
$1,680 $37,900
Cr.
Inventory- Flamenco
A/c.
$2,500 $40,400
Cr.
GST Clearing A/c. $418 $40,818 Cr.
$40,818 Cr.
$40,818 Cr.
$40,818 Cr.
$40,818 Cr.
$40,818 Cr.
$40,818 Cr.
TELEPHONE PAYABLE 201
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $375 Cr.
17-Jul Cash at Bank A/c. $375 $0
31-Jul Telephone Expenses
A/c.
$168 $168
GST Clearing A/c. $17 $185
ELECTRICITY PAYABLE 202
Post.
Date Explanation Ref. Debit Credit Balance
1-Jul Balance $150 Cr.
17-Jul Cash at Bank A/c. $150 $0 Cr.
31-Jul Electricity Expenses
A/c.
$353 $353
Cr.
GST Clearing A/c. $35 $388 Cr.
$388 Cr.