In this article we'll look at importing data like your chart of accounts and business units to a manual organisation from a CSV or Excel file.
If your organisation is linked to MYOB, Xero or QuickBooks you'll manage the data in your accounting system and sync it to Calxa as per the following articles.
Navigate to: Reports -> Report Tools -> Organisation Sync
Settings -> Organisation Settings -> Organisation Sync
Identify the Organisation you wish to import data into and click IMPORT DATA.
Select the Type of import
Actual Amounts: imports actual amounts by monthly periods. See Import Actuals for Manual Organisation for more details.
Budget Amounts: imports budget amounts by monthly periods.
Chart of Accounts: imports or updates your Chart of Accounts
Business Units: imports or updates your Business Units
Note: Accounts and Business Units are matched on the number. If the number already exists it will update this record. If the number is new it will insert a new record.
Browse and select the CSV or Excel file to import from and click NEXT STEP.
Match the Calxa fields to the columns in your spreadsheet and click NEXT STEP.
The data in your spreadsheet will be validated before any data is imported.
If errors are detected each row that contains an error will be shown.
Revise your spreadsheet data according, then select the amended file for upload.
When validation is complete and there are no errors click NEXT STEP.
When the import is complete confirm the correct number of rows were imported and click DONE.