Spreadsheet: 858684d1707287087-xlookup-or-index-match-from-another-worksheet-from-2-or-3-criteria-23-24-ytd-formula-fix
Sheet: P&L 23-24

10000000
 |  | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun
 |  | Jul-23 |  |  | Aug-23 |  |  | Sep-23 |  |  | Oct-23 |  |  | Nov-23 |  |  | Dec-23 |  |  | Jan-24 |  |  | Feb-24 |  |  | Mar-24 |  |  | Apr-24 |  |  | May-24 |  |  | Jun-24 |  | Total
Trading Income | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation | Budget | Actual | Variation
Freight Income A | 101 | 1001 |  | 201 | 2001 |  | 301 | 3001 |  | 401 | 4001 |  | 501 | 5001 |  | 601 | 6002 |  | 701 | 7001 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Freight Income Inwards | 102 | 1002 |  | 202 | 2002 |  | 302 | 3002 |  | 402 | 4002 |  | 502 | 5002 |  | 602 | 6003 |  | 702 | 7008 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Freight Income N | 103 | 1003 |  | 203 | 2003 |  | 303 | 3003 |  | 403 | 4003 |  | 503 | 5003 |  | 603 | 6004 |  | 703 | 7015 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Sales General | 104 | 1004 |  | 204 | 2004 |  | 304 | 3004 |  | 404 | 4004 |  | 504 | 5004 |  | 604 | 6005 |  | 704 | 7022 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Sales H | 105 | 1005 |  | 205 | 2005 |  | 305 | 3005 |  | 405 | 4005 |  | 505 | 5005 |  | 605 | 6006 |  | 705 | 7029 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Sales K | 106 | 1006 |  | 206 | 2006 |  | 306 | 3006 |  | 406 | 4006 |  | 506 | 5006 |  | 606 | 6007 |  | 706 | 7036 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Sales B | 107 | 1007 |  | 207 | 2007 |  | 307 | 3007 |  | 407 | 4007 |  | 507 | 5007 |  | 607 | 6008 |  | 707 | 7043 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Total Trading Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1895718690909091
Cost of Sales
Cost of Goods K |  | 1101 |  |  | 2101 |  |  | 3101 |  |  | 4101 |  |  | 5101 |  |  | 6101 |  |  | 7101 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Cost of goods B |  | 1102 |  |  | 2102 |  |  | 3102 |  |  | 4102 |  |  | 5102 |  |  | 6102 |  |  | 7102 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Cost of goods Sold - GST |  | 1103 |  |  | 2103 |  |  | 3103 |  |  | 4103 |  |  | 5103 |  |  | 6103 |  |  | 7103 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Cost of Goods Sold General - no GST |  | 1104 |  |  | 2104 |  |  | 3104 |  |  | 4104 |  |  | 5104 |  |  | 6104 |  |  | 7104 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Cost of sales H |  | 1105 |  |  | 2105 |  |  | 3105 |  |  | 4105 |  |  | 5105 |  |  | 6105 |  |  | 7105 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Freight Cost A |  | 1106 |  |  | 2106 |  |  | 3106 |  |  | 4106 |  |  | 5106 |  |  | 6106 |  |  | 7106 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Freight Cost N |  | 1107 |  |  | 2107 |  |  | 3107 |  |  | 4107 |  |  | 5107 |  |  | 6107 |  |  | 7107 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Freight inwards B |  | 1108 |  |  | 2108 |  |  | 3108 |  |  | 4108 |  |  | 5108 |  |  | 6108 |  |  | 7108 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Freight inwards H |  | 1109 |  |  | 2109 |  |  | 3109 |  |  | 4109 |  |  | 5109 |  |  | 6109 |  |  | 7109 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Freight Inwards K |  | 1110 |  |  | 2110 |  |  | 3110 |  |  | 4110 |  |  | 5110 |  |  | 6110 |  |  | 7110 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Testing |  | 1111 |  |  | 2111 |  |  | 3111 |  |  | 4111 |  |  | 5111 |  |  | 6111 |  |  | 7111 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Total Cost of Sales
Gross Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2058506522727274
Operating Expenses
Advertising | 101 | 100 |  | 101 | 100 |  | 101 | 100 |  | 101 | 100 |  | 101 | 100 |  | 101 | 100 |  | 101 | 100 |  | 101 | 0 |  | 101 | 0 |  | 101 | 0 |  | 101 | 0 |  | 101 | 0
Bank Fees | 102 | 101 |  | 102 | 101 |  | 102 | 101 |  | 102 | 101 |  | 102 | 101 |  | 102 | 101 |  | 102 | 101 |  | 102 | 0 |  | 102 | 0 |  | 102 | 0 |  | 102 | 0 |  | 102 | 0
Cleaning expense | 103 | 102 |  | 103 | 102 |  | 103 | 102 |  | 103 | 102 |  | 103 | 102 |  | 103 | 102 |  | 103 | 102 |  | 103 | 0 |  | 103 | 0 |  | 103 | 0 |  | 103 | 0 |  | 103 | 0
Computer & Software Costs | 104 | 103 |  | 104 | 103 |  | 104 | 103 |  | 104 | 103 |  | 104 | 103 |  | 104 | 103 |  | 104 | 103 |  | 104 | 0 |  | 104 | 0 |  | 104 | 0 |  | 104 | 0 |  | 104 | 0
Conference and trade show expesnes | 105 | 104 |  | 105 | 104 |  | 105 | 104 |  | 105 | 104 |  | 105 | 104 |  | 105 | 104 |  | 105 | 104 |  | 105 | 0 |  | 105 | 0 |  | 105 | 0 |  | 105 | 0 |  | 105 | 0
Consulting & Accounting | 106 | 105 |  | 106 | 105 |  | 106 | 105 |  | 106 | 105 |  | 106 | 105 |  | 106 | 105 |  | 106 | 105 |  | 106 | 0 |  | 106 | 0 |  | 106 | 0 |  | 106 | 0 |  | 106 | 0
Contracting Expense | 107 | 106 |  | 107 | 106 |  | 107 | 106 |  | 107 | 106 |  | 107 | 106 |  | 107 | 106 |  | 107 | 106 |  | 107 | 0 |  | 107 | 0 |  | 107 | 0 |  | 107 | 0 |  | 107 | 0
Credit Card Fees | 108 | 107 |  | 108 | 107 |  | 108 | 107 |  | 108 | 107 |  | 108 | 107 |  | 108 | 107 |  | 108 | 107 |  | 108 | 0 |  | 108 | 0 |  | 108 | 0 |  | 108 | 0 |  | 108 | 0
Entertainment | 109 | 108 |  | 109 | 108 |  | 109 | 108 |  | 109 | 108 |  | 109 | 108 |  | 109 | 108 |  | 109 | 108 |  | 109 | 0 |  | 109 | 0 |  | 109 | 0 |  | 109 | 0 |  | 109 | 0
Filing Fees | 110 | 109 |  | 110 | 109 |  | 110 | 109 |  | 110 | 109 |  | 110 | 109 |  | 110 | 109 |  | 110 | 109 |  | 110 | 0 |  | 110 | 0 |  | 110 | 0 |  | 110 | 0 |  | 110 | 0
Foreign Currency Conversion Fees | 111 | 110 |  | 111 | 110 |  | 111 | 110 |  | 111 | 110 |  | 111 | 110 |  | 111 | 110 |  | 111 | 110 |  | 111 | 0 |  | 111 | 0 |  | 111 | 0 |  | 111 | 0 |  | 111 | 0
Freight & Courier | 112 | 111 |  | 112 | 111 |  | 112 | 111 |  | 112 | 111 |  | 112 | 111 |  | 112 | 111 |  | 112 | 111 |  | 112 | 0 |  | 112 | 0 |  | 112 | 0 |  | 112 | 0 |  | 112 | 0
General Expenses | 113 | 112 |  | 113 | 112 |  | 113 | 112 |  | 113 | 112 |  | 113 | 112 |  | 113 | 112 |  | 113 | 112 |  | 113 | 0 |  | 113 | 0 |  | 113 | 0 |  | 113 | 0 |  | 113 | 0
Insurance | 114 | 113 |  | 114 | 113 |  | 114 | 113 |  | 114 | 113 |  | 114 | 113 |  | 114 | 113 |  | 114 | 113 |  | 114 | 0 |  | 114 | 0 |  | 114 | 0 |  | 114 | 0 |  | 114 | 0
Legal expenses | 115 | 114 |  | 115 | 114 |  | 115 | 114 |  | 115 | 114 |  | 115 | 114 |  | 115 | 114 |  | 115 | 114 |  | 115 | 0 |  | 115 | 0 |  | 115 | 0 |  | 115 | 0 |  | 115 | 0
Office Expenses | 116 | 115 |  | 116 | 115 |  | 116 | 115 |  | 116 | 115 |  | 116 | 115 |  | 116 | 115 |  | 116 | 115 |  | 116 | 0 |  | 116 | 0 |  | 116 | 0 |  | 116 | 0 |  | 116 | 0
Realised Currency Gains/Losses | 117 | 116 |  | 117 | 116 |  | 117 | 116 |  | 117 | 116 |  | 117 | 116 |  | 117 | 116 |  | 117 | 116 |  | 117 | 0 |  | 117 | 0 |  | 117 | 0 |  | 117 | 0 |  | 117 | 0
Rent | 118 | 117 |  | 118 | 117 |  | 118 | 117 |  | 118 | 117 |  | 118 | 117 |  | 118 | 117 |  | 118 | 117 |  | 118 | 0 |  | 118 | 0 |  | 118 | 0 |  | 118 | 0 |  | 118 | 0
SEO Website | 119 | 118 |  | 119 | 118 |  | 119 | 118 |  | 119 | 118 |  | 119 | 118 |  | 119 | 118 |  | 119 | 118 |  | 119 | 0 |  | 119 | 0 |  | 119 | 0 |  | 119 | 0 |  | 119 | 0
Square Fees | 120 | 119 |  | 120 | 119 |  | 120 | 119 |  | 120 | 119 |  | 120 | 119 |  | 120 | 119 |  | 120 | 119 |  | 120 | 0 |  | 120 | 0 |  | 120 | 0 |  | 120 | 0 |  | 120 | 0
Subscriptions | 121 | 120 |  | 121 | 120 |  | 121 | 120 |  | 121 | 120 |  | 121 | 120 |  | 121 | 120 |  | 121 | 120 |  | 121 | 0 |  | 121 | 0 |  | 121 | 0 |  | 121 | 0 |  | 121 | 0
Superannuation | 122 | 121 |  | 122 | 121 |  | 122 | 121 |  | 122 | 121 |  | 122 | 121 |  | 122 | 121 |  | 122 | 121 |  | 122 | 0 |  | 122 | 0 |  | 122 | 0 |  | 122 | 0 |  | 122 | 0
Telephone & Internet | 123 | 122 |  | 123 | 122 |  | 123 | 122 |  | 123 | 122 |  | 123 | 122 |  | 123 | 122 |  | 123 | 122 |  | 123 | 0 |  | 123 | 0 |  | 123 | 0 |  | 123 | 0 |  | 123 | 0
Travel - International | 124 | 123 |  | 124 | 123 |  | 124 | 123 |  | 124 | 123 |  | 124 | 123 |  | 124 | 123 |  | 124 | 123 |  | 124 | 0 |  | 124 | 0 |  | 124 | 0 |  | 124 | 0 |  | 124 | 0
Travel - National | 125 | 124 |  | 125 | 124 |  | 125 | 124 |  | 125 | 124 |  | 125 | 124 |  | 125 | 124 |  | 125 | 124 |  | 125 | 0 |  | 125 | 0 |  | 125 | 0 |  | 125 | 0 |  | 125 | 0
Unrealised Currency Gains/Losses | 126 | 125 |  | 126 | 125 |  | 126 | 125 |  | 126 | 125 |  | 126 | 125 |  | 126 | 125 |  | 126 | 125 |  | 126 | 0 |  | 126 | 0 |  | 126 | 0 |  | 126 | 0 |  | 126 | 0
Wages and Salaries | 127 | 126 |  | 127 | 126 |  | 127 | 126 |  | 127 | 126 |  | 127 | 126 |  | 127 | 126 |  | 127 | 126 |  | 127 | 0 |  | 127 | 0 |  | 127 | 0 |  | 127 | 0 |  | 127 | 0
Total Operating Expenses
Net Profit