accounting

profilecand
myobexceldata.xlsx
Home>Business & Finance homework help>Accounting homework help>accounting

GENERAL JOURNAL

General Journal
1/07/2018 To 31/07/2018
ID# Acct# Account Name Debit Credit Job No.
GJ 9/07/2018 owner invested additional cash in business
GJ000001 1-1110 Cheque Account $499,930.00
GJ000001 3-1100 Owner/Sharehldr Capital $499,930.00
GJ 10/07/2018 bank charges
GJ000002 6-1200 Bank Charges $23.00
GJ000002 1-1110 Cheque Account $23.00
Grand Total: $499,953.00 $499,953.00

&8&D &8MYOB / Excel &8&T

PAYROLL

Payroll Journal
1/07/2018 To 31/07/2018
ID# Account # Account Name Hours Debit Credit Job No.
26/07/2018 vokerla vokerla *None 293 568 111
10 1-1110 Cheque Account $2,809.50
6-5130 Base Hourly 80 $3,847.50
2-1410 PAYG Withholding $1,038.00
31/07/2018 vokerla vokerla *None 293 568 111
9 1-1110 Cheque Account $2,087.25
6-5130 Base Hourly 56 $2,693.25
2-1410 PAYG Withholding $606.00

&8&D &8MYOB / Excel &8&T

SALES

Sales & Receivables Journal
1/07/2018 To 31/07/2018
ID# Acct# Account Name Debit Credit Job No.
SJ 2/07/2018 Sale; Savy customer
00000001 1-1200 Trade Debtors $70,700.00
00000001 4-1100 Sales, Food $70,700.00
SJ 20/07/2018 Savy customer: Discounts on 00000001
00000002 1-1200 Trade Debtors $707.00
00000002 5-3000 Discounts Given $707.00
SJ 20/07/2018 Savy customer: Credit from 00000002
SJ000001 1-1200 Trade Debtors $707.00
SJ000001 1-1200 Trade Debtors $707.00
SJ 31/07/2018 Savy customer: Credit from w/o00001
SJ000003 1-1200 Trade Debtors $69,993.00
SJ000003 1-1200 Trade Debtors $69,993.00
SJ 31/07/2018 Write-off; Savy customer
w/o00001 1-1200 Trade Debtors $69,993.00
w/o00001 6-1120 BAD DEBT $69,993.00
Grand Total: $212,100.00 $212,100.00

&8&D &8MYOB / Excel &8&T

PURCHASE

Purchases & Payables Journal
1/07/2018 To 31/07/2018
ID# Acct# Account Name Debit Credit Job No.
PJ 5/07/2018 Purchase; ABC supplier
00000001 2-1200 Trade Creditors $60,070.00
00000001 5-2000 Cost Of Sales - Beverage $60,070.00
PJ 30/07/2018 ABC supplier: Discounts on 00000001
00000002 2-1200 Trade Creditors $600.70
00000002 6-1600 Discounts Taken $600.70
PJ 30/07/2018 ABC supplier: Debit from 00000002
PJ000001 2-1200 Trade Creditors $600.70
PJ000001 2-1200 Trade Creditors $600.70
Grand Total: $61,271.40 $61,271.40

&8&D &8MYOB / Excel &8&T

INVENTORY

Inventory Journal
1/07/2018 To 31/07/2018
ID# Acct# Account Name Debit Credit Job No.
IJ 10/07/2018 Inventory count
IJ000001 1-1310 Inventory, Food $204.00
IJ000001 1-1310 Inventory, Food $204.00
IJ 10/07/2018 Inventory count
IJ000002 1-1310 Inventory, Food $266.00
IJ000002 1-1310 Inventory, Food $266.00
Grand Total: $470.00 $470.00

&8&D &8MYOB / Excel &8&T

BANKING-REPAYMENTS

g
Cash Disbursements Journal
1/07/2018 To 31/07/2018
ID# Acct# Account Name Debit Credit Job No.
CD 23/07/2018 self
4 1-1110 Cheque Account $12.00
4 6-1200 Bank Charges $12.00
CD 26/07/2018 vokerla vokerla
10 1-1110 Cheque Account $2,809.50
10 6-5130 Wages & Salaries $3,847.50
10 2-1410 Payroll Accruals Payable $1,038.00
CD 30/07/2018 ABC supplier
3 1-1110 Cheque Account $59,469.30
3 2-1200 Trade Creditors $59,469.30
CD 31/07/2018 self
5 1-1110 Cheque Account $13.00
5 6-1200 Bank Charges $13.00
CD 31/07/2018 vokerla vokerla
9 1-1110 Cheque Account $2,087.25
9 6-5130 Wages & Salaries $2,693.25
9 2-1410 Payroll Accruals Payable $606.00
Grand Total: $66,035.05 $66,035.05

&8&D &8MYOB / Excel &8&T

BANKING RECEIPTS

Cash Receipts Journal
1/07/2018 To 31/07/2018
ID# Acct# Account Name Debit Credit Job No.
CR 20/07/2018 Payment; Savy customer
CR000001 1-1110 Cheque Account $69,993.00
CR000001 1-1200 Trade Debtors $69,993.00
CR 23/07/2018 Cheque bounced: CR000001; Savy customer
CR000002 1-1110 Cheque Account $69,993.00
CR000002 1-1200 Trade Debtors $69,993.00
Grand Total: $139,986.00 $139,986.00

&8&D &8MYOB / Excel &8&T

BANK RECONCILIATION

Reconciliation Report
ID# Date Memo/Payee Deposit Withdrawal
Cheque Account: 1-1110 Cheque Account
Date of Bank Statement: 31/07/2018
Reconciled Cheques
GJ000002 10/07/2018 bank charges $23.00
4 23/07/2018 self $12.00
CR000002 23/07/2018 Cheque bounced: CR000001; Savy customer $69,993.00
10 26/07/2018 vokerla vokerla $2,809.50
3 30/07/2018 ABC supplier $59,469.30
5 31/07/2018 self $13.00
9 31/07/2018 vokerla vokerla $2,087.25
Total: $0.00 $134,407.05
Reconciled Deposits
GJ000001 9/07/2018 owner invested additional cash in business $499,930.00
CR000001 20/07/2018 Payment; Savy customer $69,993.00
Total: $569,923.00 $0.00
Reconciliation
AccountRight Plus Balance on 31/07/2018: $885,550.95
Add: Outstanding Cheques: $0.00
Subtotal: $885,550.95
Deduct: Outstanding Deposits: $0.00
Expected Balance on Statement: $885,550.95

&8&D &8MYOB / Excel &8&T

PROFIT & LOSS

Profit & Loss Statement
July 2018
Income
Sales
Sales, Food $70,700.00
Total Sales $70,700.00
Total Income $70,700.00
Cost Of Sales
Cost Of Sales - Beverage $60,070.00
Discounts Given $707.00
Total Cost Of Sales $60,777.00
Gross Profit $9,923.00
Expenses
General & Administrative Exp
BAD DEBT $69,993.00
Bank Charges $48.00
Discounts Taken ($600.70)
Total General & Administrative Exp $69,440.30
Employment Expenses
Wages & Salaries $6,540.75
Total Employment Expenses $6,540.75
Total Expenses $75,981.05
Operating Profit ($66,058.05)
Other Income
Other Expenses
Net Profit / (Loss) ($66,058.05)

&8&D &8MYOB / Excel &8&T

BALANCE SHEET

Balance Sheet
As of July 2018
Assets
non_crnt_tax_furniture&fixes $3,014.00
crnt_tax_furniture&fixtures $1,514.00
Current Assets
Cash On Hand
Cheque Account $885,550.95
Payroll Cheque Account $2,000.00
Cash Drawer $500.00
Petty Cash $400.00
Total Cash On Hand $888,450.95
Trade Debtors $50,000.00
Less Prov'n for Doubtful Debts ($5,000.00)
Inventories
Inventory, Food $20,000.00
Inventory, Beverages $25,000.00
Inventory, Supplies $15,000.00
Total Inventories $60,000.00
Prepaid Insurance $5,000.00
Total Current Assets $998,450.95
Fixed Assets
Land $800,035.00
Buildings and Improvements
Bldgs & Imprvmnts at Cost $400,000.00
Bldgs & Imprvmnts Accum Dep ($8,000.00)
Total Buildings and Improvements $392,000.00
Furniture and Fixtures
Furniture & Fixtures at Cost $80,000.00
Furniture & Fixtures Accum Dep ($8,000.00)
Total Furniture and Fixtures $72,000.00
China, Glass, Silver & Linen
China, Etc. at Cost $30,000.00
China, Etc. Accum Dep ($3,000.00)
Total China, Glass, Silver & Linen $27,000.00
Total Fixed Assets $1,291,035.00
Total Assets $2,294,013.95
Liabilities
Current Liabilities
Trade Creditors $30,000.00
GST Liabilities
GST Collected $2,000.00
GST Paid $3,000.00
Total GST Liabilities $5,000.00
Payroll Liabilities
Payroll Accruals Payable $16,644.00
PAYG Withholding Payable $5,000.00
Total Payroll Liabilities $21,644.00
Customer Deposits $4,000.00
Total Current Liabilities $60,644.00
Long Term Liabilities
Bank Loans $500,070.00
Total Long Term Liabilities $500,070.00
Total Liabilities $560,714.00
Net Assets $1,733,299.95
Equity
Owner/Sharehldr Equity
Owner/Sharehldr Capital $1,299,930.00
Total Owner/Sharehldr Equity $1,299,930.00
Retained Earnings $499,428.00
Current Year Earnings ($66,058.05)
Total Equity $1,733,299.95

&8&D &8MYOB / Excel &8&T