How to Correct Incorrectly Imported Sales Ledger Invoices

If sales ledger invoices have been imported incorrectly, they can be easily corrected. The system allows you to reverse the original import by re-importing the same file with adjustments. This avoids the need for manual deletion of individual invoices.

When to Use This Process

• When an entire batch of invoices has been imported with incorrect values.

• When invoices have been imported against the wrong account or nominal code.

• When date errors or incorrect amounts have been uploaded.

How to Reverse an Import

The correction process is straightforward and involves reversing the values of the original import.

1. Locate the original CSV file used for the incorrect import.

2. Open the file in your spreadsheet software.

3. Switch all monetary values from positive to negative:

   • Net_Amount: Change all values to negative.

   • Vat: Change all values to negative.

   • Gross_Amount: Change all values to negative.

4. Save the file.

5. Navigate to Accounts > Sales Ledger > Import Invoices.

6. Select the same Nominal Date that was used in the original import.

7. Click Locate to select the corrected CSV file.

8. Click Import.

This will reverse the effects of the original import, effectively cancelling out the incorrect invoices.

Additional Notes

• Always double-check the adjustments before importing to ensure all values have been properly reversed.

• It is advisable to run a small test with just one reversed invoice first.

• If you do not have the original file, you will need to manually recreate it with the identical details, except with negative values.

• Reversing an import does not delete the original file - it simply balances it out in the Sales Ledger.