Opening balances are totals of the outstanding invoices and credit notes you have before you start using Accounting. To save time, you can import an opening balances file. To import an opening balances file, you must: - Already have entered customers or suppliers
- Set an accounts start date and VAT scheme
- Ensure that the file contains only customer or supplier opening balances. To import both, you need two separate files
- Save the file in comma-separated value (CSV) format
- Ensure that the file uses the same column headings and formatting as in the customers or suppliers opening balances template file
If you have bank or ledger account opening balances, you can enter them manually. For more information, see Enter bank account opening balances or Entering ledger account opening balances. We recommend downloading the template file available within your application and then adding your data to the template. This helps prevent formatting issues that could hinder the successful import of your file. - Go to Settings, then Business Settings.
- In the Opening Balances section, select Customers or Suppliers.
- Click New Opening Balance and then select Import Opening Balances.
- Click the hyperlink to download the template CSV file.
- Go to the downloads folder on your computer to find the file.
If you already have a file, compare it to the template file before importing your opening balances. The column headings and data format in your file must match the template. If you don't have a file, you can add your data to the template file. Leave the column headings as-is and then replace the sample data with your data, using the same format.  NOTE: The maximum file size you can import is 0.5MB. If your file is larger, split it into another file.
When preparing your file, use the tables below to ensure that your file format is correct. Use the table that applies to your VAT scheme. Remember that the header row in your CSV file must use the same headings as shown in the Field Name column below. Customer opening balances file format Invoice Basis | Column | Field Name | Type | Compulsory | Notes | | A | Type | Text | Yes | When dealing with invoices, enter "Invoice"; for credit notes, input "Cr Note." Use "Cr Note" for outstanding payments on account, You can allocate them at a later date. | | B | Date | Numbers | Yes | Must be in the format dd/mm/yyyy. | | C | Customer Name | Text | Yes | Enter the customer’s name as it appears on their record. | | D | Customer Reference | Text and numbers | Yes | Enter the customer’s unique reference as it appears in their record. | | E | Reference | Text and numbers | Yes | Enter a reference of your choice, for example, an invoice number. | | F | Details | Text and numbers | No | If required, enter any additional details up to a maximum of 25 characters. | | G | Total | Number plus 2 decimal places | No | Enter the gross value of the transaction. | Cash Basis | Column | Field Name | Type | Compulsory | Notes | | A | Type | Text | Yes | When dealing with invoices, enter "Invoice"; for credit notes, input "Cr Note." Use "Cr Note" for outstanding payments on account, You can allocate them at a later date. | | B | Date | Numbers | Yes | Must be in the format dd/mm/yyyy. | | C | Customer Name | Text | Yes | Enter the customer’s name as it appears on their record. | | D | Customer Reference | Text and numbers | Yes | Enter the customer’s unique reference as it appears in their record. | | E | Reference | Text and numbers | Yes | Enter a reference of your choice, for example, an invoice number. | | F | Details | Text and numbers | No | If required, enter any additional details up to a maximum of 25 characters. | | G | Net | Number plus 2 decimal places | No | Enter the net value of the transaction. | | H | VAT Rate | Text | No | Enter one of the following VAT rates:
* Standard
* Reduced rate
* Second reduced rate
* Zero rated
* Exempt * No VAT | | I | VAT | Number plus 2 decimal places | No | Enter the VAT element of the transaction. | | J | Total | Number plus 2 decimal places | No | Enter the total gross value of the transaction.
The net and VAT amounts must equal the total value otherwise the import will fail. | Supplier opening balances file format Invoice Basis | Column | Field name | Type | Compulsory | Notes | | A | Type | Text | Yes | When dealing with invoices, enter "Invoice"; for credit notes, input "Cr Note." Use "Cr Note" for outstanding payments on account, You can allocate them at a later date. | | B | Date | Numbers | Yes | Must be in the format dd/mm/yyyy. | | C | Customer Name | Text | Yes | Enter the supplier’s name as it appears on their record. | | D | Customer Reference | Text and numbers | Yes | Enter the supplier’s unique reference as it appears in their record. | | E | Reference | Text and numbers | Yes | Enter a reference of your choice, for example, an invoice number. | | F | Details | Text and numbers | No | If required, enter any additional details up to a maximum of 25 characters. | | G | Total | Number plus 2 decimal places | No | Enter the gross value of the transaction. | Cash Basis | Column | Field Name | Type | Compulsory | Notes | | A | Type | Text | Yes | When dealing with invoices, enter "Invoice"; for credit notes, input "Cr Note." Use "Cr Note" for outstanding payments on account, You can allocate them at a later date. | | B | Date | Numbers | Yes | Must be in the format dd/mm/yyyy. | | C | Customer Name | Text | Yes | Enter the supplier’s name as it appears on their record. | | D | Customer Reference | Text and numbers | Yes | Enter the supplier’s unique reference as it appears in their record. | | E | Reference | Text and numbers | Yes | Enter a reference of your choice, for example, an invoice number. | | F | Details | Text and numbers | No | If required, enter any additional details up to a maximum of 25 characters. | | G | Net | Number plus 2 decimal places | No | Enter the net value of the transaction. | | H | VAT Rate | Text | No | Enter one of the following VAT rates:
* Standard
* Reduced rate
* Second reduced rate
* Zero rated
* Exempt * No VAT If you deal with VAT-registered EU suppliers or suppliers outside of the EU, enter "No VAT" and then input the gross value of the transaction in the Net and Total columns. This process is necessary because VAT on these transactions is accounted for when creating the invoice, not when receiving or making the payment. If you haven’t yet accounted for the VAT in your previous system, you can manually adjust your next VAT return to include the necessary values. | | I | VAT | Number plus 2 decimal places | No | Enter the VAT element of the transaction. | | J | Total | Number plus 2 decimal places | No | Enter the total gross value of the transaction.
The net and VAT amounts must equal the total value otherwise the import will fail. | - Go to Settings, then Business Settings.
- In the Opening Balances section, select Customers or Suppliers.
- Select New Opening Balance and then select Import Opening Balances.
- Select Choose File. Browse to your opening balances CSV file and then click Open.
- Click Upload.
- When prompted that the upload was successful, click OK.
VAT considerations after importing In the Cash Basis VAT Scheme, when you handle transactions with VAT-registered EU customers outside the EU, the system defaults to No VAT for the VAT rate, and it displays the gross value in the Net and Total columns. This occurs because the system accounts for VAT on these transactions when you create the invoice, not when you receive or make the payment. If you haven't yet accounted for the VAT in your previous system, you need to manually adjust your next VAT return to include the necessary values. If you’re importing from Sage Accounts, the VAT rate appears based on the tax code you used for each transaction. If for any reason you amended the VAT rate percentage in Sage Accounts, you can click the transaction to manually amend the net and VAT amounts then Save. NOTE: If you amend any of the values, it will adjust the Trade Debtors control account balance. This will create a difference in the Trial Balance report from Sage Accounts. When entering your nominal opening balances, you'll need to decide where to post the difference. For example, you may want to post it to Corrections. If you have errors appearing preventing your upload, read more on common import errors. [BCB:299:UKI - Personal content block - Dane:ECB] [BCB:303:UKI - Search override - Accounting IE:ECB] [BCB:276:UKI - hide back button:ECB] |