- Home
- Conversions, Guides, Systems & Checklists
- Sheets & XLSX
-
XYZ & GPFR in Xero
- XYZ & GPFR In Xero Checklist
- XYZ Model Financial Accounts & Checkpoint
- GPFR Refresher
- GPFR in Xero Set Up
- Use Your GPFR In Xero System
- Structure
- Revenue
- Retentions, Receivables & Payables
- Provisions & Employee Benefits
- Inventory & Work In Progress
- Intangible Assets
- Related Parties & Key Management Personnel
- Property, Plant & Equipment
- Deferred Tax & Tax Effect Accounting
- Leases & Right Of Use Assets
- Cash Flow
- Changes in Equity
- Consolidated Financial Reporting
- Audit & Lodgement
-
Example Reports
-
AASB 1060 Tier 2 Resources
-
Conversions, Guides, Systems & Checklists
-
SPFR in Xero
-
I want a GPFR prepared
Use excel / sheets to check "match" of columns
If you need to see if one column matches another, use the function
We had to see if the words in one column were an exact match to the words in another column.
So we used this formula:
=IF(B5=E5, "Match", "No Match)")
Here is an example: