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 ...

    • Unleashed | Adding products in bulk via import

      Managing a large inventory can be a daunting task, but with Unleashed, we aim to simplify it for you. Importing products in bulk is not just a time-saver, but it ensures accuracy and consistency in your inventory data. Make sure your product data is ...

    • Adding products in Bulk via CSV import

      Adding product manually is ok if you have only a few items. In case, there are 100s of products, using CSV to import them will make task easy. The Retail POS product template is attached with this article. It is a pre-formatted templatethat includes ...

    • 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 ...