Enter multiple manual journals using an import template
Add multiple draft manual journals at once by entering the details into a CSV template and importing it into Xero.
- Download a manual journal template file from Xero
- Enter journal details into the template
- Save your file in CSV format
- Import the template file back into Xero
Download a manual journal template file from Xero
- In the Advisor menu, select Manual Journals.
- Click Import.
- Click Download template file.
Enter journal details into the template
In a spreadsheet editor such as Microsoft Excel, open the manual journal template file you've downloaded from Xero. The column headings in the first row guide you what to enter in each column.
You can use one CSV template to create:
- One draft manual journal
- Multiple draft manual journals
To create a single draft manual journal, use the same date and narration for each line that you enter.
Enter a new narration, a different date, or both, for each separate journal you want to create.
Enter journal details into these fields:
- TrackingName1 and TrackingOption1, TrackingName2 and TrackingOption2
One narration for each manual journal. Use the same narration and date for each group of rows you want to import as lines in the same journal. This field is mandatory.
This field is mandatory.
Date format needs to be either mm/dd/yyyy or mmm dd yyyy. For example, 6/30/2015 or Jun 30 2015.
You can have a different description for each row or journal line. This field is optional.
AccountCode is the account code number from your chart of accounts. For example, 200, not 200 - Sales. This field is mandatory.
Enter the full tax rate name as it appears in your tax settings in Xero. For example, 'Sales Tax on Imports'. This field is mandatory.
Amount will be treated as debit if the amount is positive, or credit, if negative. This field is mandatory.
Enter the tracking category and related tracking option within the category that you want to use with the journal. These fields are optional. However, they must be valid values in Xero, and the value entered for the option must match the category.
In the Settings menu, select General Settings, then click Tracking to see your tracking categories and options.
Save your file in CSV format
Save your file with .csv as the file extension. For example, you might name your file 2015Journals.csv.
Import the template file back into Xero
- In Xero, return to the Import Manual Journal screen and click Browse. Select your file.
- Click Import to upload the file and create a draft manual journal in Xero. (Or click Cancel to return to the previous screen.)
- Review the message in Xero and click Complete Import if you're happy with the results.