Chart of Accounts Mapping Template

Last updated on Invalid Date

Exporting From Xero (Manually)

From your Xero dashboard - select “Accounting” and go to “Reports”

Notion image
 
 

On the Reports page, scroll down to "Financial Statements" and select "Profit & Loss”

Notion image
 

Select the "Current Financial Year By Month" report If you want to change the date, you can edit it on this page

Notion image
 

Select Export to Google Sheets

Notion image
 

Manually format the data

Notion image
 

Paste the data into the welcome sheet

Be sure to keep the column format the same & overwrite any formulas and dummy data that already exists in the welcome sheet import section

Notion image

Repeat process on a weekly/monthly basis to keep the sheet updated

 

Exporting From Xero (Automatically)

Install our google add-on

https://workspace.google.com/u/0/marketplace/app/gini_turn_your_xero_ data_into_ai_financi/427137331014?hl=en&pann=sheets_addon_widget

 

On the Mapping Sheet, select the gini add-on in the extensions tab, and choose “sync data”

Notion image
 

Authorize Xero, and choose the organization you want to sync. Copy the Sheet Name in the Destination

Notion image
 

Paste the sheet name over the blue text to the right of “Import Sheet Name”

Notion image
 

Mapping Expenses

All your expense categories will now be displayed under the categorisation section. You can select either Sales & Marketing, General & Admin, or R&D as a mapping category for each of your expense categories.

 

Categorise your expenses

Notion image

Breakdown Categories

Notion image

Some categories, such as Salary, may need to be broken down into the subcategories.

In order to do this, create a Breakdown name (such as Salary) and input the % of each category you want the category broken down into. Once this is done, return to the mapping table, and map any categories you want to be broken down to the new Breakdown category.

Notion image
 
Did this answer your question?
😞
😐
🤩