VIRTUAL BOOKKEEPER
ALMA
PENAFIEL
PORTFOLIO
XERO
ACCOUNTING
QUICKBOOKS
ACCOUNTING
QUICKBOOKS
DESKTOP
REAL ESTATE BOOKKEEPINGG
CLEAN UP & CATCH UP
Balance Sheet
XERO Booster Skill Test _Alma Penafiel
As at 31 July 2023
31 JUL 2023
Assets
Bank
WestPac ***5512
308,140.97
Total Bank
308,140.97
Current Assets
Prepayments
170.41
Total Current Assets
170.41
Total Assets
308,311.38
Liabilities
Current Liabilities
GST
5,301.05
Historical Adjustment
(485,344.00)
Total Current Liabilities
(480,042.95)
Total Liabilities
(480,-,354.33
Net
Assets
Current Year Earnings
53,010.33
Equity
Owner A Share Capital
(100,000.00)
Retained Earnings
835,344.00
Total Equity
788,354.33
Balance Sheet
XERO Booster Skill Test _Alma Penafiel
27 Sep 2023
Page 1 of 1
Profit and Loss
XERO Booster Skill Test _Alma Penafiel
For the year ended 30 June-
Trading Income
Sales
675,000.00
Total Trading Income
675,000.00
Cost of Sales
Cost of Goods Sold
(146,500.00)
Total Cost of Sales
(146,-,500.00
Gross Profit
Operating Expenses
Advertising
(300.00)
Bank Fees
(150.00)
Cleaning
(100.00)
Consulting & Accounting
(2,500.00)
Freight & Courier
(130.00)
General Expenses
(625.00)
Insurance
(1,500.00)
Interest Expense
(153.00)
Legal expenses
(1,000.00)
Light, Power, Heating
(575.00)
Meals and Entertainment
(200.00)
Motor Vehicle Expenses
(255.00)
Office Expenses
(256.00)
Parking fees
(300.00)
Printing & Stationery
(100.00)
Rent
(5,000.00)
Subscriptions
(200.00)
Telephone & Internet
(500.00)
Total Operating Expenses
(13,-,344.00
Net Profit
Profit and Loss
XERO Booster Skill Test _Alma Penafiel
27Sep2023 Page1of1
Executive Summary
XERO Booster Skill Test _Alma
Penafiel For the month ended 31 July
2023
JUL 2023
JUN 2023
VARIANCE
66,050
250,00
-74
7,909
0-
%-
Cash
Cash received
Cash spent
Cash surplus (deficit)
58,141
250,00
-77
Closing bank balance
308,141
0
%
250,00
23%
60,04
675,000
0
-91%
5-
(146,500)
100
60,04
821,500
%
5-
-
-93%
-
Profitability
Income
Direct costs
Gross profit (loss)
Other income
Expenses
7,035
(13,844)
Profit (loss)
53,01
835,344
0
Balance Sheet
151
%
Debtors
-
-
-94%-
Creditors
-
-
-
788,354
735,344
7%
Number of invoices issued
-
-
-
Average value of invoices
-
-
-
Net assets
Sales
Performance
Gross profit margin (%)
10
122
-18
Net profit margin (%)
0
124
%
Return on investment (p.a.) (%)
88
1,363
-29
81
Position
%
Average debtor days
-
-
-94 -
Average creditor days
-
-
% -
Short term cash forecast
-
-
-
(1)
(1)
-25%
-
-
-
Current assets to liabilities
Term assets to liabilities
Management Report
XEROBoosterSkillTest_AlmaPenafiel
Activity Statement
ABC PTY LTD
For the period ending 30 September 2022
ABN
GST Accounting Method
Cash Basis
PAYG Tax Withheld (Sep)
Total salary, wages and other payments
Amount withheld from payments shown at W1
Amount withheld where no ABN is quoted
Other amounts withheld (excluding any amount shown in W2 or W4)
Total amounts withheld (W2 + W4 + W3)
W
34,085
1
5,041
W
2
W
5,041
Amounts you owe the Tax Office
4
PAYG tax withheld
W
4
3
5,04
5
5,04
Total owed to the ATO
Amounts the Tax Office owes you
Total owed by the ATO
Payment or Refund
8A
W
8B
1
1
0
Is 8A more than 8B?
Yes
Your payment
9
Activity Statement | ABC PTY LTD | 30 September 2022
5,041
Page 1 of 1
Executive Summary
B2 - ALMA PENAFIEL
For the month ended September 30, 2023
SEP 2023
AUG 2023
VARIANCE
Cash received
-
-
-
Cash spent
-
-
-
Credit Card payments
-
-
-
Surplus (deficit)
-
-
-
Cash
Closing bank balance
123,689.00
123,689.00
-
Profitability
Income
-
-
-
Direct costs
-
-
-
Gross profit (loss)
-
-
-
Other income
-
-
-
1,150.00
1,150.00
-
(1,150.00)
(1,150.00)
-
9,100.00
9,100.00
-
-
-
-
65,358.44
66,508.44
-1.73%
Number of invoices issued
-
-
-
Average value of invoices
-
-
-
Gross profit margin (%)
-
-
-
Net profit margin (%)
-
-
-
(21.11)
(20.75)
-1.76%
Average debtor days
-
-
-
Average creditor days
-
-
-
9,100.00
9,100.00
-
1.31
1.32
-0.96%
Expenses
Profit (loss)
Balance Sheet
Debtors
Creditors
Net assets
Sales
Performance
Return on investment (p.a.) (%)
Position
Short term cash forecast
Current assets to liabilities
Management Report
B2 - ALMA PENAFIEL
Oct7,2023 Page1of8
Cash Summary
B2 - ALMA PENAFIEL
For the month ended September 30, 2023
SEP 2023
MONTHLY
AVERAGE
(YTD)
Other Income
-
3.22
Sales
-
4,855.56
%
Total Income
-
4,858.78
-100.00%
-100.00
-
21.11
-100.00%
1,000.00
1,000.00
0.00%
Light power heating
-
166.67
-100.00%
Meals & Entertainment
-
333.33
-100.00%
Miscellaneous
-
16.67
-100.00%
Office supplies Expense
-
55.56
-100.00%
Rent Expense
-
666.67
-100.00%
Software expense
150.00
150.00
0.00%
Wages & Salaries
-
555.56
-100.00%
Total Expenses
1,150.00
2,965.56
-61.22%
Surplus (Deficit)
(1,150.00)
1,893.22
-160.74%
Fixed Assets
-
(3,388.89)
100.00%
Advances from customer
-
444.44
-100.00%
Amount due from owner
-
(555.56)
100.00%
1,000.00
1,000.00
0.00%
-
277.78
-100.00%
150.00
(816.67)
118.37%
Short term loan payable
-
11,111.11
-100.00%
Vendor Deposits
-
(666.67)
100.00%
1,150.00
7,405.56
-84.47%
-
9,298.78
-100.00%
VARIANCE
Income
Less Expenses
-100.00
%
Bank Service Charges
Interest Expense
Plus Other Cash Activity
Interest Payable
Payroll Wages Payable
Prepayments
Total Other Cash Activity
Net Cash Flows
Management Report
B2 - ALMA PENAFIEL
Oct7,2023 Page3of8
Aged Receivables Summary
B2 - ALMA PENAFIEL
As of September 30,
2023 Ageing by due date
1 - 30 DAYS
31 - 60 DAYS
61 - 90 DAYS
OLDER
TOTAL
Mary Jane Watson
-
-
-
4,400.0
4,400.0
Otis Milburn
-
-
-
0
0
Total
-
-
-
4,700.0
9,100.0
4,700.0
9,100.0
-
0
0
0
0
100.00
100.00
%
%
CONTACT
Percentage of total
Management Report
-
B2 - ALMA PENAFIEL
Oct7,2023 Page7of8
-
Balance Sheet
B2 - ALMA PENAFIEL
As of September 30, 2023
SEP 30, 2023
SEP 30, 2022
Assets
Current Assets
Cash and Cash Equivalents
ELITE BANK
Total Cash and Cash Equivalents
123,689.00
20,000.00
123,689.00
20,000.00
Accounts Receivable
9,100.0
Amount due from owner
0
-
Prepayments
5,000.0
-
Vendor Deposits
0
-
7,-,139.00
Total Current Assets
24,500.00
44,500.00
0
Fixed Assets
-
Computer & Office Equipment
6,000.0
-,500.00
Furniture
6,000.00
-
Less-Accumulated Depreciation: Computer & Office Equipment
(680.56)
-
29,719.44
-
180,858.44
44,500.00
Accumulated Depreciation-Office Furniture
Total Fixed Assets
Total Assets
-
Liabilities and Equity
Liabilities
Current Liabilities
Accounts Payable
-
1,000.00
Advances from customer
4,000.00
-
Interest Payable
9,000.00
-
Payroll Wages Payable
2,500.00
-
Short term loan payable
100,000.00
-
Total Current Liabilities
Total Liabilities
Equity
115,500.0
1,000.0
0
0
115,500.0
1,000.0
0 1,858.44
Current Year Earnings
Owner's Capital
30,000.0
Retained Earnings
0
33,500.0
65,358.44
Total Equity
0
180,858.44
Total Liabilities and Equity
0
-
30,-,500.0
43,-,500.0
0
Management Report
B2 - ALMA PENAFIEL
Oct7,2023 Page6of8
Income Statement
B2 - ALMA PENAFIEL
For the month ended September 30, 2023
SEP 2023
AUG 2023
YEAR TO DATE
Income
Sales
-
-
27,800.00
Total Income
-
-
27,800.00
Gross Profit
-
-
27,800.00
-
-
190.00
Operating Expenses
Bank Service Charges
Depreciation
-
-
780.56
1,000.00
1,000.00
9,000.00
Meals & Entertainment
-
-
3,000.00
Miscellaneous
-
-
150.00
Office supplies Expense
-
-
500.00
Rent Expense
-
-
6,000.00
Software expense
150.00
150.00
1,350.00
Wages & Salaries
-
-
5,000.00
1,150.00
1,150.00
25,970.56
(1,150.00)
(1,150.00)
1,829.44
Interest Expense
Total Operating Expenses
Operating Income
Other Income / (Expense)
Other Income
-
-
29.00
Total Other Income / (Expense)
-
-
29.00
(1,150.00)
(1,150.00)
1,858.44
Net Income
Management Report
B2 - ALMA PENAFIEL
Oct7,2023 Page5of8