Import multiple manual journals
Create the manual journal template file, then import it into Xero:
- In the Accounting menu, select Reports.
- Under Accounting, click Journal Report.
- Click Manual Journals, then click Import.
- Click Download template file.
Enter the journal details into the template.
If you leave both the date and narration cells blank, Xero treats that row as belonging to the same journal as the row above it.
- Save the file with .csv as the file extension. For example, 2019Journals.csv.
- In Xero, return to the Import Manual Journal screen, click Browse, then select the file.
- Click Import, review the message, then click Complete Import.
Related Articles
Record movements in system accounts
Record movements in system accounts Accounts receivable, accounts payable and wages payable are system accounts. Xero automatically creates default system accounts for specific reporting or accounting purposes. They will always balance, and equal the ...
Import Purchases
You can import purchase orders in bulk into your account. All imported purchase orders will be added to your account in a Parked status, allowing you to confirm the transactions before approving them. Before You Begin Read the following topics to ...
Import Sales Orders
You must import sales orders using the Unleashed template. Before You Begin Read the following topics to understand the correct process details and avoid common errors: Data Import Checklist Troubleshooting Import Errors Points to Note: Order ...
PO Sheet Import Guide
Once you have created your Vend PO CSV, you'll need to import it into your store. 1. To place an order or do an initial stock upload, you must first navigate to Products -> Stock control in the sidebar and then select the Order Stock button. Once ...
Setting up the import file
Setting up the import files To import inventory items via our Retail Imports team, please refer to this article. The Item Import tool extracts your inventory data from an import file (CSV or Excel file) that you create and then upload to the Item ...