Setting Up And Processing Transactions In Xero For Sugariffic – August 2018
- December 28, 2023/ Uncategorized
| Aged Payables Detail | |||||||||
| Sugariffic | |||||||||
| As at 31 August 2018 | |||||||||
| Invoice Date | Due Date | Invoice Reference | Current | < 1 Month | 1 Month | 2 Months | 3 Months | Older | |
| Fixxy Drinx | |||||||||
| 03 Aug 2018 | 30 Sep 2018 | 1,980.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
| Total Fixxy Drinx | 1,980.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Parental Consent Required | |||||||||
| 29 Aug 2018 | 30 Oct 2018 | 4,598.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
| Total Parental Consent Required | 4,598.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Sweet Treats | |||||||||
| 03 Aug 2018 | 30 Sep 2018 | 4,730.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
| 03 Aug 2018 | 30 Sep 2018 | 7,700.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
| 14 Aug 2018 | 30 Sep 2018 | 10,230.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
| Total Sweet Treats | 22,660.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Total | 29,238.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Aged Receivables Detail | |||||||||
| Sugariffic | |||||||||
| As at 31 August 2018 | |||||||||
| Invoice Date | Due Date | Invoice Number | Invoice Reference | Current | < 1 Month | 1 Month | 2 Months | 3 Months | Older |
| Decadent D’Quay | |||||||||
| 20 Aug 2018 | 19 Sep 2018 | SI-1000007 | 23,925.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 28 Aug 2018 | 27 Sep 2018 | SI-1000011 | 3,382.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Total Decadent D’Quay | 27,307.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Lollies Online | |||||||||
| 27 Aug 2018 | 26 Sep 2018 | SI-1000010 | 1,837.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Total Lollies Online | 1,837.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Tactix | |||||||||
| 21 Aug 2018 | 20 Sep 2018 | SI-1000008 | 2,898.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 30 Aug 2018 | 29 Sep 2018 | SI-1000013 | 10,384.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Total Tactix | 13,282.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Total | 42,427.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Trial Balance | |||||||||
| Sugariffic | |||||||||
| As at 31 August 2018 | |||||||||
| Account Code | Account | Account Type | Debit | Credit | 31 Aug 2017 | ||||
| 230 | Sales – Chocolates | Sales | 55,105.00 | 0.00 | |||||
| 240 | Sales – Lollies | Sales | 15,025.00 | 0.00 | |||||
| 250 | Sales – Drinks | Sales | 4,320.00 | 0.00 | |||||
| 330 | Cost of Sales – Chocolates | Direct Costs | 13,700.00 | 0.00 | |||||
| 340 | Cost of Sales – Lollies | Direct Costs | 12,020.00 | 0.00 | |||||
| 350 | Cost of Sales – Drinks | Direct Costs | 1,440.00 | 0.00 | |||||
| 400 | Advertising | Expense | 4,180.00 | 0.00 | |||||
| 461 | Printing & Stationery | Expense | 480.00 | 0.00 | |||||
| 469 | Rent | Expense | 2,200.00 | 0.00 | |||||
| 477 | Wages and Salaries | Expense | 4,400.00 | 0.00 | |||||
| 600 | Cash at Bank | Bank | 72,570.50 | 0.00 | |||||
| 610 | Accounts Receivable | Current Asset | 42,427.00 | 0.00 | |||||
| 640 | Inventory – Chocolates | Current Asset | 3,575.00 | 0.00 | |||||
| 650 | Inventory – Lollies | Current Asset | 8,580.00 | 0.00 | |||||
| 660 | Inventory – Drinks | Current Asset | 360.00 | 0.00 | |||||
| 710 | Office Equipment | Fixed Asset | 11,770.00 | 0.00 | |||||
| 730 | Furniture and Fittings | Fixed Asset | 16,200.00 | 0.00 | |||||
| 800 | Accounts Payable | Current Liability | 29,238.00 | 0.00 | |||||
| 820 | GST | Current Liability | 214.50 | 0.00 | |||||
| 910 | New Business Bank Loan | Non-current Liability | 35,000.00 | 0.00 | |||||
| 970 | Owners Contribution | Equity | 55,000.00 | 0.00 | |||||
| Total | 1,93,902.50 | 1,93,902.50 | 0.00 | ||||||
| Balance Sheet | |||||||||
| Sugariffic | |||||||||
| As at 31 August 2018 | |||||||||
| Account | 31 Aug 2018 | ||||||||
| Assets | |||||||||
| Bank | |||||||||
| Cash at Bank | 72,570.50 | ||||||||
| Total Bank | 72,570.50 | ||||||||
| Current Assets | |||||||||
| Accounts Receivable | 42,427.00 | ||||||||
| Inventory – Chocolates | 3,575.00 | ||||||||
| Inventory – Drinks | 360.00 | ||||||||
| Inventory – Lollies | 8,580.00 | ||||||||
| Total Current Assets | 54,942.00 | ||||||||
| Fixed Assets | |||||||||
| Furniture and Fittings | 16,200.00 | ||||||||
| Office Equipment | 11,770.00 | ||||||||
| Total Fixed Assets | 27,970.00 | ||||||||
| Total Assets | 1,55,482.50 | ||||||||
| Liabilities | |||||||||
| Current Liabilities | |||||||||
| Accounts Payable | 29,238.00 | ||||||||
| GST | 214.50 | ||||||||
| Total Current Liabilities | 29,452.50 | ||||||||
| Non-current Liabilities | |||||||||
| New Business Bank Loan | 35,000.00 | ||||||||
| Total Non-current Liabilities | 35,000.00 | ||||||||
| Total Liabilities | 64,452.50 | ||||||||
| Net Assets | 91,030.00 | ||||||||
| Equity | |||||||||
| Current Year Earnings | 36,030.00 | ||||||||
| Owners Contribution | 55,000.00 | ||||||||
| Total Equity | 91,030.00 | ||||||||
| GST Reconciliation | |||||||||
| Sugariffic | |||||||||
| From 1 July 2018 to 31 August 2018 | |||||||||
| Accruals Basis | |||||||||
| GST Collected | |||||||||
| GST Period | GST Collected | Adjustments | Filed | Unfiled | |||||
| Opening Balance | $0.00 | ||||||||
| 1 Jul 18 – 31 Aug 18 | $7,445.00 | $7,445.00 | |||||||
| Total | $7,445.00 | $0.00 | $0.00 | $7,445.00 | |||||
| GST Paid | |||||||||
| GST Period | GST Paid | GST On Imports | Adjustments | Filed | Unfiled | ||||
| Opening Balance | $0.00 | ||||||||
| 1 Jul 18 – 31 Aug 18 | $7,230.50 | $0.00 | $7,230.50 | ||||||
| Total | $7,230.50 | $0.00 | $0.00 | $0.00 | $7,230.50 | ||||
| GST Account Transactions | |||||||||
| Date | Transaction | Amount | |||||||
| Total | $0.00 | ||||||||
| GST Owing | |||||||||
| Opening Balance | $0.00 | ||||||||
| Plus GST Collected and Filed | $0.00 | ||||||||
| Less GST Paid and Filed | $0.00 | ||||||||
| Less Payments Made | $0.00 | ||||||||
| Closing Balance | $0.00 | ||||||||
| GST Account Summary | |||||||||
| GST Owing | $0.00 | ||||||||
| Unfiled GST | $214.50 | ||||||||
| Balance at 31 August 2018 | $214.50 | ||||||||
| GST Account Balance | $214.50 | ||||||||
