What type of information can I import?
Description

The data you can import depends on your variant of Sage 50 Accounts. The Exceptions column shows which data types you can't import.

TIP: When importing records, if a record with the same reference already exists in your accounts, that record is updated. Transaction records and records with new references create new entries in your accounts. Use our handy guide to see the Data fields you can import.

Cause
Resolution

Areas you can import

AreaCan import?Exceptions
Audit trail transactions
View Transaction types >
YesYou can't import the following:



  • Foreign bank transactions - you must enter these manually
  • Sales receipt (SR) - Instead, import as a sales payment on account (SA) and then manually allocate
  • Purchase payment (PP) - Instead, import as a purchase payment on account (PA) and then manually allocate
  • Sales discount (SD) - Instead, import as a sales credit (SC) and then manually allocate
  • Purchase discount (PD) - Instead, import as a purchase credit (PC) and then manually allocate
  • CIS deductions or payments on account for CIS purposes
  • When entering a Project Ref against certain transactions (for example purchase invoice (PI) and bank payments (BP)), you must also enter a Code Code and vice versa
  • Sage 50 Accounts v29.0 and below: Charities - you can't import a transaction with a fund reference. As a workaround, you can import and then Correct the transaction to add the fund reference
  • When importing journals from the audit trail any cost codes and project references are not imported
Bank accountsSee exceptions.

You must import bank accounts as nominal records and then convert them manually to bank accounts. First import the bank nominal codes, then:

  1. Click Bank accounts then click New/edit.
  2. In A/C Ref enter the required nominal code and press Enter.
  3. When the message 'A nominal account with this reference already exists - do you wish to convert it to a bank account?' appears, click Yes.
  4. Click Save then click Close.
Customer recordsYesYou can't import customer delivery addresses.
Fixed asset recordsYesNone
Invoice and creditsNo

You can't import into the Invoices and credit module.

You can import sales invoice (SI) and sales credit (SC) transactions as audit trail transactions.

Alternatively, there may be a Sage partner that can offer you a solution. For more information, please visit the Sage 50 Marketplace.

Nominal accounts and standard budgetsYes

You can't import advanced budget information.

You can check if you use the standard or advanced budgeting method in SettingsCompany Preferences on the Budgeting tab.

Price listsSee exceptions.

You must import price lists from within the price list record.

Product recordsYes

You can't import the following:

  • Bill of materials (BOM) information
  • Quantity in stock - Instead you can import an adjustment in (AI) stock transaction for the required quantity
  • Sage 50 Accounts v28.0 and below:  Intrastat duty code - the 2-digit field after commodity code
Project recordsYesNone
Project-only transactionsYesNone
Purchase ordersNoYou can't import into the Purchase order module.

However, there may be a Sage partner that can offer you a solution. For more information, please visit the Sage 50 Marketplace.
Sales ordersNoYou can't import into the Sales order module.

However, there may be a Sage partner that can offer you a solution. For more information, please visit the Sage 50 Marketplace
QuotationsNoYou can't import into the Quotations module.

However, there might be a Sage partner that can offer you a solution. For more information, please visit the Sage 50 Marketplace.
Stock takeYesNone
Stock transactionsYes

You can't import the following:

  • Movement out (MO) - Instead, import as an adjustment out (AO)
  • Movement in (MI) - Instead, import as an adjustment in (AI)
Subcontractors recordsNo

You can't import CIS information into supplier records to create subcontractors.

Instead, import the supplier record, and then enter the CIS information manually.

CIS subcontractor transaction
No

You can't import CIS subcontractor transactional information.

Supplier recordsYesYou can't import supplier delivery addresses.

Values you can import

For more information on what individual values you can import in each area, please refer to the Data fields you can import guide.

[BCB:116:Limitless - 50 Accounts - Import / Export:ECB]

[BCB:191:UKI - #GetMoreFeedback:ECB] [BCB:259:UKI - Personal content block - Anth:ECB]








Steps to duplicate
Related Solutions