Import multiple manual journals

Import multiple manual journals

Create the manual journal template file, then import it into Xero:

  1. In the Accounting menu, select Reports.
  2. Under Accounting, click Journal Report.
  3. Click Manual Journals, then click Import.
  4. Click Download template file.
  5. 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.

  6. Save the file with .csv as the file extension. For example, 2019Journals.csv.
  7. In Xero, return to the Import Manual Journal screen, click Browse, then select the file.
  8. 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 ...