Spreadsheet: 781479d1653368429-index-match-formula-with-nested-error-test-that-has-an-error-that-is-unsolvable-forum-test-2021-22-accounts
Sheet: Account List

Account Source | Account Number | Account Group Number | Type | [NAME] Type | Description | 1
 | 0 | 0 |  |  |  | 2
BT Investors Choice | 1002 |  | Bank | Cash and cash equivalents | Money Market | 3
RABO Bank | 1003 |  | Bank | Cash and cash equivalents | Holding Account | 4
HSBC Day-to-Day Account | 1004 |  | Bank | Savings | Day-to-Day Account | 5
Macquarie Bank - Personal | 1005 |  | Bank | Cash and cash equivalents | Personal Income and Expenses | 6
Macquarie Bank - Superannuation | 1006 |  | Bank | Cash and cash equivalents | Superannuation Income and Expenses | 7
Super Account | 1007 |  | Bank | Cash and cash equivalents |  | 8
Val Pocket | 1008 |  | Bank | Cash | Cash Transactions | 9
NAB Credit Card | 1010 |  | Credit card | Credit Card |  | 10
Westpac Credit Card | 1012 |  | Credit card | Credit Card |  | 11
Paypal | 1014 |  | Cash and cash equivalents | Cash and cash equivalents |  | 12
Stock on Hand | 1016 |  | Current assets | Inventory | Inventory | 13
Uncategorised Asset | 1018 |  | Current assets | Other current assets |  | 14
Undeposited Funds | 1020 |  | Current assets | Undeposited Funds | Money not yet deposited | 15
Office Furniture and Equipment | 1022 |  | Fixed assets | Other fixed assets |  | 16
PAYG Instalments Payable | 1024 |  | Current liabilities | Current Liabilities |  | 17
Opening Balance Equity | 1026 |  | Owner's equity | Opening Balance Equity | Offset used to enter account balances | 18
Personal | 2000 |  | Owner's equity | Owner's Equity |  | 19
Personal - Accounting | 2001 |  | Owner's equity | Owner's Equity |  | 20
Personal - Bank Charges | 2010 |  | Owner's equity | Owner's Equity |  | 21
Personal - Christmas | 2020 |  | Owner's equity | Owner's Equity |  | 22
Personal - Clothing | 2030 |  | Owner's equity | Owner's Equity |  | 23
Personal - Computers - Hardware | 2031 |  | Owner's equity | Owner's Equity |  | 24
Personal - Computers - Software | 2032 |  | Owner's equity | Owner's Equity |  | 25
Personal - DeWayne Car | 2040 |  | Owner's equity | Owner's Equity | Repayments from loan | 26
Personal - Dining | 2050 |  | Owner's equity | Owner's Equity |  | 27
Personal - Dividend | 2060 |  | Owner's equity | Owner's Equity |  | 28
Personal - Donations | 2070 |  | Owner's equity | Owner's Equity |  | 29
Personal - Financial Advisor Fees | 2072 |  | Owner's equity | Owner's Equity |  | 30
Personal - Flying | 2080 |  | Owner's equity | Owner's Equity |  | 31
Personal - Gifts | 2090 |  | Owner's equity | Owner's Equity |  | 32
Personal - Groceries | 2100 |  | Owner's equity | Owner's Equity |  | 33
Personal - Hangar | 2110 |  | Owner's equity | Owner's Equity |  | 34
Personal - Hangar Expenses | 2112 |  | Owner's equity | Owner's Equity |  | 35
Personal - Hangar Income | 2114 |  | Owner's equity | Owner's Equity |  | 36
Personal - Health | 2130 |  | Owner's equity | Owner's Equity |  | 37
Personal - Health - Complimentary | 2132 |  | Owner's equity | Owner's Equity |  | 38
Personal - Health - Fitness | 2134 |  | Owner's equity | Owner's Equity |  | 39
Personal - Health - Government | 2136 |  | Owner's equity | Owner's Equity | Government Health System | 40
Personal - Health - Medicines | 2138 |  | Owner's equity | Owner's Equity |  | 41
Personal - Household | 2150 |  | Owner's equity | Owner's Equity |  | 42
Personal - Insurance | 2160 |  | Owner's equity | Owner's Equity |  | 43
Personal - Interest Paid | 2170 |  | Owner's equity | Owner's Equity |  | 44
Personal - Interest Received | 2180 |  | Owner's equity | Owner's Equity |  | 45
Personal - Mason Stevens | 2190 |  | Owner's equity | Owner's Equity | Super Investments | 46
Personal - Miscellaneous | 2220 |  | Owner's equity | Owner's Equity | Miscellaneous Income and Expenses | 47
Personal - Motor | 2240 |  | Owner's equity | Owner's Equity |  | 48
Personal - Motor - Fuel & Oil | 2242 |  | Owner's equity | Owner's Equity |  | 49
Personal - Motor - Other Expenses | 2244 |  | Owner's equity | Owner's Equity |  | 50
Personal - Motor - Registration & Insurances | 2246 |  | Owner's equity | Owner's Equity |  | 51
Personal - Other Expenses | 2260 |  | Owner's equity | Owner's Equity |  | 52
Personal - Owner's Equity | 2270 |  | Owner's equity | Owner's Equity |  | 53
Personal - R+R | 2280 |  | Owner's equity | Owner's Equity |  | 54
Personal - Rates - Council | 2302 |  | Owner's equity | Owner's Equity |  | 55
Personal - Super | 2350 |  | Owner's equity | Owner's Equity |  | 56
Personal - Tax | 2360 |  | Owner's equity | Owner's Equity |  | 57
Personal - Travel | 2370 |  | Owner's equity | Owner's Equity |  | 58
Personal - UK Pension | 2380 |  | Owner's equity | Owner's Equity |  | 59
Personal - Utilities | 2390 |  | Owner's equity | Owner's Equity |  | 60
[NAME] | 3000 |  | Owner's equity | [NAME] |  | 61
Business Income | 4000 |  | Income | Service/Fee Income |  | 62
Business Income - Commission | 4010 |  | Income | Service/Fee Income | Patient Orders | 63
Business Income - Consultation | 4020 |  | Income | Service/Fee Income | Naturopathy | 64
Business Income - Massage | 4030 |  | Income | Other curr operating inc. |  | 65
Business Income - Reflexology | 4040 |  | Income | Service/Fee Income |  | 66
Business Income - Supplements | 4050 |  | Income | Sales of Product Income |  | 67
Other Income | 4100 |  | Income | Service/Fee Income |  | 68
Business Cost of Sales | 4200 |  | Cost of sales | Supplies and materials - COS |  | 69
Business Cost of Sales - Reflexology | 4210 |  | Cost of sales | Cost of Sales |  | 70
Business Cost of Sales - Massage | 4220 |  | Cost of sales | Cost of Sales |  | 71
Business Cost of Sales - Supplements | 4230 |  | Cost of sales | Cost of Sales |  | 72
Business Cost of Sales - Other | 4240 |  | Cost of sales | Cost of Sales |  | 73
Business Expenses | 4300 |  | Expenses | Office/General [NAME] |  | 74
Business Expenses - Accounting | 4310 |  | Expenses | Legal and professional fees |  | 75
Business Expenses - Advertising | 4320 |  | Expenses | Advertising/Promotional |  | 76
Business Expenses - Association Memberships | 4330 |  | Expenses | Dues and Subscriptions | Professional memberships | 77
Business Expenses - Bank Charges & Fees | 4340 |  | Expenses | Bank charges |  | 78
Business Expenses - Computers | 4350 |  | Expenses | Office/General [NAME] |  | 79
Business Expenses - Computers -Hardware | 4352 |  | Expenses | Office/General [NAME] |  | 80
Business Expenses - Computers - Internet | 4354 |  | Expenses | Office/General [NAME] |  | 81
Business Expenses - Computers - Other | 4356 |  | Expenses | Office/General [NAME] |  | 82
Business Expenses - Computers - Subscriptions | 4358 |  | Expenses | Office/General [NAME] |  | 83
Business Expenses - Computers - Software | 4360 |  | Expenses | Office/General [NAME] |  | 84
Business Expenses - Donations | 4380 |  | Expenses | Charitable Contributions | Cash an [NAME] donated to charity | 85
Business Expenses - Education | 4400 |  | Expenses | External services |  | 86
Business Expenses - Education - Books | 4402 |  | Expenses | External services |  | 87
Business Expenses - Education - Courses | 4404 |  | Expenses | External services |  | 88
Business Expenses - Education - Other | 4406 |  | Expenses | External services |  | 89
Business Expenses - General Expenses | 4420 |  | Expenses | Office/General [NAME] |  | 90
Business Expenses - Insurance | 4430 |  | Expenses | Insurance |  | 91
Business Expenses - Interest Expense | 4440 |  | Expenses | Interest paid |  | 92
Business Expenses - Postage | 4450 |  | Expenses | Office/General [NAME] |  | 93
Business Expenses - Repairs and Maintenance | 4460 |  | Expenses | Repair and maintenance |  | 94
Business Expenses - Stationery | 4470 |  | Expenses | Office/General [NAME] |  | 95
Business Expenses - Telephone | 4480 |  | Expenses | Utilities |  | 96
Business Expenses - Travel Expenses | 4490 |  | Expenses | Travel |  | 97
Business Expenses - Utilities | 4500 |  | Expenses | Utilities | Electricity, Water | 98
Interest Income | 5000 |  | Other income | Interest earned |  | 99
Uncategorised Expense | 6000 |  | Expenses | Other Misc Service Cost |  | 100