Spreadsheet: 839539d1692055937-conditional-formatting-highlight-numbers-from-a-range-ignore-the-blank-cells-portfolio-1-invoices-on-hold-2023-test
Sheet:  Jan 22

2022-01-01 00:00:00 |  |  |  |  |  | LEGEND |  |  | Invoices Awaiting Approval or Has [NAME] (Not Paid)
Total Invoices |  |  |  |  |  | R | Ready for ACM Approval (CC has updated invoice in SW) |  | January |  | July
Invoices Paid |  |  |  | Adriana |  | A | Awaiting Approval to Pay - i.e. Insufficient Funds / Awaiting Chair Approval / etc |  | February |  | August
 |  |  |  | Cell above must be name as in your email |  | Q | Invoice on list but not in SW - CC Query |  | March |  | September
 |  |  |  |  |  | Y | AM has Authorised Invoice in SW |  | April |  | October
 |  |  |  | Ctrl + ↓ Takes you to the last entry |  |  | CC to Fix Common Property Inv |  | May |  | November
 |  |  |  | Ctrl + Home Key takes you to the top of the Spreadsheet |  | Del | Invoice to be Deleted / Not to be Paid |  | June |  | December
 |  |  |  |  |  | ON | On - charge
Date Paid / Action | Date Imported from SW | PlanNo | Invoice Date | Invoice From  (copy from [NAME] export) | Invoice no. | Due Date | Reference | Amount | Category line count | Accrue From Date | Accrue To Date | BPAY Biller | BPAY Reference | Head Category(copy from chart of accounts export) | Sub Category(copy from category export) | admin | sink | GST | AgentEmail
 |  | 180623 | 2021-12-30 00:00:00 | Top Grass Limited | 49883 | 2022-01-01 00:00:00 | Lawn Mowing | 80 | 1 | 2021-12-30 00:00:00 | 2021-12-30 00:00:00 | 0 | 0 | Done | 0 | 80 | 0 | GST | [EMAIL]
 | 2022-01-03 00:00:00 | 96486 | 2021-12-31 00:00:00 | Finer Crafts Ltd - Owen Finer | 5999 | 2022-01-01 00:00:00 | Job 94 ELLIS RD | 45 | 1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 0 | 0 | Garden/Lawn Maintenance | 0 | 45 | 0 | GST | [EMAIL]
 | 2022-01-03 00:00:00 | 371169 | 2021-12-31 00:00:00 | Just Energy (Pulse Energy) | 9088708407 | 2022-01-18 00:00:00 | Electricity 29/11/2021 - 28/12/2021 | 117.66 | 1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 0 | 0 | Electricity | 0 | 117.66 | 0 | GST | [EMAIL]
 | 2022-01-03 00:00:00 | 129088 | 2021-12-31 00:00:00 | Corporate Property Services (2014) Ltd | 14958 | 2022-01-20 00:00:00 | Garden Maintenance for [EMAIL] GST | 107.33 | 1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 0 | 0 | Garden/Lawn Maintenance | 0 | 107.33 | 0 | GST | [EMAIL]
 | 2022-01-03 00:00:00 | 166208 | 2022-01-01 00:00:00 | CoveKinloch Compliance Ltd | INV-6944 | 2022-01-02 00:00:00 | Building Compliance Service | 3201.68 | 1 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 0 | 0 | Consultant | Building Compliance / BWOF(Building Warranty of Fitness) | 3201.68 | 0 | GST | [EMAIL]
 | 2022-01-03 00:00:00 | 185216 | 2022-01-01 00:00:00 | Compliance Consultants Limited | 2009551 | 2022-02-20 00:00:00 | Building warrant of fitness | 193.2 | 1 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 0 | 0 | Consultant | Building Compliance / BWOF(Building Warranty of Fitness) | 193.2 | 0 | GST | [EMAIL]
 | 2022-01-03 00:00:00 | 127189 | 2022-01-01 00:00:00 | Compliance Consultants Limited | 2009578 | 2022-02-20 00:00:00 | Building warrant of fitness | 160 | 1 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 0 | 0 | Consultant | Building Compliance / BWOF(Building Warranty of Fitness) | 160 | 0 | GST | [EMAIL]
 | 2022-01-03 00:00:00 | 100089 | 2021-12-31 00:00:00 | Mackay Cleaning Services Limited | INV-11269 | 2022-01-20 00:00:00 | General [NAME] | 132.25 | 1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 0 | 0 | Done | 0 | 132.25 | 0 | GST | [EMAIL]
 | 2022-01-05 00:00:00 | 166208 | 2022-01-04 00:00:00 | Spark New Zealand Trading Ltd | 190183645 | 2022-01-20 00:00:00 | Manager's Office Phone & Mobiles | 68.13 | 1 | 2022-01-04 00:00:00 | 2022-01-04 00:00:00 | 0 | 0 | [NAME] | telephone charges | 68.13 | 0 | GST | [EMAIL]
 | 2022-01-06 00:00:00 | 94024 | 2022-01-01 00:00:00 | A D T Fire Monitoring | 50806854 | 2022-02-20 00:00:00 | Fire System Monitoring 01/01/2022 - 31/03/2022 | 220.14 | 1 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 0 | 0 | Fire Protection Services | monitoring | 220.14 | 0 | GST | [EMAIL]
 | 2022-01-06 00:00:00 | 127189 | 2021-12-31 00:00:00 | Mackay Cleaning Services Limited | INV-11272 | 2022-01-20 00:00:00 | Spider Treatment | 1897.5 | 1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 0 | 0 | Done | 0 | 1897.5 | 0 | GST | [EMAIL]
 | 2022-01-06 00:00:00 | 127189 | 2021-12-31 00:00:00 | Mackay Cleaning Services Limited | INV-11271 | 2022-01-20 00:00:00 | General Cleaning | 465.52 | 1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 0 | 0 | Done | 0 | 465.52 | 0 | GST | [EMAIL]
 | 2022-01-06 00:00:00 | 494243 | 2021-12-31 00:00:00 | Schindler Lifts N Z Limited | 5503602839 | 2022-01-20 00:00:00 | Scheduled lift maintenance | 1425.57 | 1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 0 | 0 | [NAME] | 0 | 1425.57 | 0 | GST | [EMAIL]
 | 2022-01-06 00:00:00 | 371169 | 2021-12-31 00:00:00 | [NAME]'s Mowing - Cro Corp Ltd | 11071 | 2022-01-06 00:00:00 | Lawnmowing services Monthly charge | 92.6 | 1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 0 | 0 | Garden/Lawn Maintenance | 0 | 92.6 | 0 | GST | [EMAIL]
 | 2022-01-06 00:00:00 | 494243 | 2022-01-01 00:00:00 | Trustpower Limited | 5046024905 | 2022-01-19 00:00:00 | Electricity 19/11/2021 - 20/12/2021 | 363.25 | 1 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 0 | 0 | Electricity | 0 | 363.25 | 0 | GST | [EMAIL]