such as Dext, Lightyear, or Datamolino. You scan the bills and submit the scans to the add-on solution, which extracts the core details and pushes them into Xero. Such add-on solutions normally have a 14-day free trial, which allows you to check out whether you’d like to use the add-on for your business.
Bank transactions
Perhaps you’ve decided on a conversion date and set up your bank accounts in Xero; however, a gap occurs between the conversion date and the date the bank feeds activate, or perhaps your bank doesn’t offer bank feeds. In this case, you can manually import statements — see Chapter 4 for further guidance on how to do this.
Follow these steps to import Bank Transactions into Xero:
1 From the top menu bar, go to Accounting → Bank Accounts → Relevant Bank Account, click the Manage Account button on the top right, and select the Import a Statement link.The Import Bank Transactions window opens.
2 Click the Browse button to select the required file and then click the green Import button.For example, you could select the <Bank>Import.csv file from the DataReadyForImporting folder in the CONVERSION folder.The Statement Import Options window opens (see Figure 3-8).
3 In the blue Statement Lines Imported from Your File box, under the Assign To column, click on the drop-down menu and select the Xero bank statement fields the imported data should be matched to.The available bank statement fields in Xero are Transaction Date, Transaction Amount, Payee, Description, Reference, Transaction Type, Cheque No., Account Code, Tax Type, Analysis Code and Region. A Xero field can only be selected once.The table on the right of the box highlights the outcomes of your selections. Use the Next option to see the potential treatment of the next imported transaction. The statement fields can be reselected until you’re happy the transactions showing are correct.
4 Make sure that the date format reflects the transactions that you’re importing.You are prompted to confirm the date format; remember that this format will be used in future. If you need to change it, click on the drop-down menu and select your preferred date format.
5 Check the box labelled Don’t Import the First Line.You check this box because the first line is a column heading.
6 Once you’re satisfied the data suitably matches, click the green Save button.A pop up window confirms statement lines were imported.
7 Click OK.The Bank Reconciliation window opens, because the imported transactions need to be reconciled — see Chapter 8 for guidance on reconciling bank transactions.
8 Process the other bank transactions files by repeating Steps 1 to 7.
Source: Xero 2022
FIGURE 3-8: The Statement Import Options window.
Manual journals
Xero does not recommend importing manual journals during the conversion process because, preferably, transactions should be allocated to the correct area rather than via a manual journal. If you do decide entering a manual journal is the best solution, remember that only a user with Standard user status and above can access the manual journal area.
To import manual journals into Xero, follow these steps:
1 From the dashboard, users with Adviser access go to Accounting → Advanced → Manual Journals, and then click the Import button. Users with Standard user access go to Accounting → Reports → Journal Reports and then click the Add New Journal hyperlink.The Import Manual Journal window opens.
2 Click the Browse button to select the required file and then click the blue Import button.For example, you could select the ManualJournalsImport.csv file from the DataReadyForImporting folder in the CONVERSION folder.To create a single draft manual journal, use the same date and narration for each line that you enter. To create multiple draft manual journals, enter a new narration, a different date, or both, for each separate journal you want to create.Clicking the Import button displays a report on the impending import process in the Import Manual Journal window. It stresses the action cannot be undone!
3 Review the report integrity.If further editing of the data is required, click the grey Go Back button and review the imported data file.
4 Once satisfied, click the green Complete Import button to import the manual journal(s).The imported data is classified as a draft manual journal on the Manual Journals dashboard.
5 Post the journal entry by clicking on it, reviewing that the details are complete and correct, and clicking the green Post button.This is a journal entry so debits must equal credits. Also, check the consumer tax has been applied as required. The manual journal is now listed as a posted manual journal.
6 Process the other imported manual journals by repeating Steps 1 to 5.
Fixed assets
Only a user with Adviser status can tackle some of the processes related to fixed assets. To import fixed assets into Xero, follow these steps:
1 From the Xero Dashboard go to Accounting → Advanced → Fixed Assets and click on the Import button.To set up the Start Date, check out Chapter 14 (the Start Date is the date that you want Xero to start calculating depreciation on your registered fixed assets).The Import Fixed Assets window opens.
2 Make sure that the asset types in the file exist in Xero.To set up new asset types, see Chapter 14.
3 Select your preferred date format from the drop-down menu.
4 Click the Browse button to select the required file and then click the blue Continue button.For example, you could select the FixedAssetsImport.csv file from the DataReadyForImporting folder in the CONVERSION folder.Clicking the Import button opens the Import Fixed Assets window, which provides a report on the impending import process, and highlights the action can’t be undone.
5 Review the report integrity.If further editing of the fixed asset data is required, click the grey Back button and review the imported data file.
6 Once satisfied, click the Import button.The fixed assets are imported as a draft.
7 Review the imported fixed assets by clicking on the individual asset under the Draft tab and updating the details as required.See Chapter 14 for guidance on fixed asset details.
8 Once satisfied, a user with Adviser status can move the fixed asset from the Draft tab to the Registered tab by clicking the check box beside it and clicking the Register button.The asset is now a part of the Fixed Asset Register.
9 Check the details of the other imported fixed assets and register them by repeating Steps 7 to 8.
Unpresented
