Restore to an error free backup and reprocess

1. On the menu bar, go to Help, then select About.
2. Under Data Information, make a note of the following figures: Headers, Splits, Invoices, Sales Orders, and Purchase Orders.
3. On the menu bar, go to File then select Backup and, if prompted, press No to the check data message.
4. Enter a file name for your backup, then press Browse.
5. Browse to where you want to save it and press OK. 
6. Select the Data Files checkbox then press OK.
7. Press No then OK.

Make a note of the last transaction number on the error free backup, and the last invoice, credit, and order numbers.

1. On the menu bar, go to File then select Restore.
2. Press Browse then browse to where you saved your backup.
3. Select it then Press Open. 
4. Press OK then Yes.
5. Press OK, enter your logon name and password, then press OK.

Export the following reports

Check all reports before re-entering as they can be inaccurate due to the corruption. Depending on the extent of corruption, some transactions won't export.

Transactions

1. Go to Transactions, then Reports, and select Transactions on the left.
2. Select the Transaction CSV (PP=>PA AND SR=>SA) report and press Export.
3. Select the Save as type dropdown and choose CSV Files (*.csv). 
4. Browse to a location of your choice and press Save.
5. In Criteria Values window, select Between (Inclusive) in the Transaction No line.
6. In the first field, enter one number higher than the transaction number noted in step 3. For example, in step 3 you noted 5000, enter 5001.
7. In the second field, enter 9999999 then press OK.

Customer, supplier, and product records

Export the following reports as a CSV files:

Invoices and orders

If you use Invoices and credits, sales orders, or purchase orders, print any invoices or orders after the numbers noted in step 3:

Stock

Once reprocessing is complete, run a product details report to check stock levels.

1. Go to Products and services, select Reports, then select Product details.
2. Select the Product Details report and choose either Print or Export as required.

VAT Return

1. Go to VAT, select the required Return, then select VAT Return at the top of the window.
2. Press Print and select the VAT Return, Summary and Detailed checkboxes.
3. Select Printer, press Run, then OK.
4. Repeat from step 1 for all affected VAT Returns.

Bank Reconciliation

1. Go to Bank Accounts and open the required bank account.
2. Select the Memo tab and open the Statements folder.
3. Double-click and print the required statements.

1. On the menu bar, go to File then select Restore.
2. Press Browse then browse to where you saved your backup.
3. Select it then press Open. 
4. Press OK then Yes.
5. Press OK, enter your logon name and password, then press OK.
6. Now you've restored your backup. We recommend you check your data.

The Backup Manager simplifies your backup routine. It schedules automatic backups, words while you use Sage 50 Accounts or while it's closed. it also runs Check data automatically and you'll see check data results for all companies in one place.

To set up a backup schedule:

1. Open Sage Accounts and log in using the manager logon name and password.
2. On the menu bar, go to File, select Schedule back up, then select the Settings tab.
3. Enter your backup schedule settings as required. Follow our manage your scheduled backups and check data results article.

Import any customers, suppliers, or products

If you've added customers, suppliers or product codes since the error-free backup, import the relevant CSV report from step 5. Or, you can manually add the new records required.

1. On the menu bar, go to File, then select Import then press Next.
2. In the Data type window, select the type of data you want to import, then press Next.
3. In the Data source window, select Comma separated (*.csv).
4. Press Browse and locate and select the file to import.
5. Press Open then Next.
6. Press Load Map then select Shared mappings.
7. Select the extended map, for example Customer record (extended).map, then press Open.
8. Press Next, then select Import or Finish.
9. If the import is successful, a list of transactions imported appears in the Record Imported pane. Press Close.
   
   If the import is unsuccessful, a list of import errors appear in the Records not Imported pane.
10. If available, press Edit import to amend the original import file, then press Close.  
11. Attempt to import again.

Re-enter invoices and orders

Re-enter any Invoices and credits and/or Sales orders, and Purchase orders you printed in step 5.

When reprocessing, if you update the ledger for these invoices and orders, you must delete the transactions to avoid duplication when importing your audit trail.

Imported audit trail

Before importing, check for errors:

1. Delete any incorrect transactions and remove cancelled transactions.

To import your audit trail file:

1. On the menu bar, go to File, select Import, then press Next.
2. Select Audit Trail transactions then press Next.
3. In the Data source window, select Comma separated (*.csv).
4. Press Browse and locate and select the file to import.
5. Press Open then press Next.
6. Press Load Map then open Shared mappings.
7. Select Transaction (extended).map then press Open.
8. Press Next then select Import or Finish.
9. If the import is successful, a list of transactions imported appears in the Records Imported pane.
10. Press Close.
    
    If the import is unsuccessful, a list of import errors appear in the Records not Imported pane.
11. If available, press Edit import to amend the original import file, then press Close.
12. Attempt to import again.
13. Re-allocate any transactions as the import routine doesn't allocate them automatically.
    TIP:

    If you’re importing .csv files, Excel can show credits as a negative value that can affect your import. We recommended that you change negative values to positive values before importing.

       

Reprocess VAT Returns

Reprocess and reconcile any VAT Returns and mark as submitted if applicable. You don't need to resubmit the return to HMRC.

You don't need to post the VAT transfer or post any payment or receipt. The audit trail import above includes these.

Bank reconciliation

1. Reprocess any bank reconciliations based on the reports you printed in step 6 above.

Stock

Check the Product details report you ran in step 5.

1. If any stock levels are different, correct the quantities and cost prices.
2. Once you’ve completed the steps, check your data, backup and then start processing as normal.