How do I reverse entries that were imported into General Ledger?
Description
Cause
Resolution

Entries have not been posted:

See How do I move unposted and unwanted transactions out of my General Ledger new file using the Move option?

 

Entries have been posted:

Option 1: Correct the original import file

  1. Correct the entries in the original import file to have the reversing signs.
  2. Import the file again with the corrections. See How to import transactions in General Ledger.

 

Option 2: Create a reversing import file from posted entries

  1. Download and save the GL Import Transactions Report below. See How do I save, add, and print a report design? for steps to save the report.
    Attachment: GLImportTransactions.rpt
  2. From the Reports Menu, select the report from step 1.
  3. Select the appropriate transaction file and click OK.
  4. Select an option from the What to do? list.
    • Reverse Transactions: Creates transactions with revering signs in the original debit / credit column.
    • Reenter Transactions: Creates transactions with original signs in the opposite debit / credit column.
  5. Enter a date range for the transactions you intend to reverse or reenter in the Non Required Accounting Date Range box.
  6. Select the appropriate accounting method for the import transactions.
    Note: To verify your accounting method settings, from the File menu, select Company Settings, General.
  7. Clear the Original Transaction Description check box.
    Note: Because many transaction descriptions include commas, it is best to not use the original description. When this box is cleared, the description on the reverse transaction is (Rev) Import Transaction and the reenter transaction description is Import Transaction. This differentiates the reverse and reenter transactions from the original transactions.
  8. Click Conditions and add conditions for Application of Origin (GL) and Batch.
  9. Click Printer Setup and select the Print to file check box.
  10. Click OK and then click Start.
  11. In the Print File Selection window, from the Save as type list, select Plain Text (*.txt).
  12. Specify a location in the Save in list.
  13. Enter a file name in the File name box and then click Save.
  14. Import the reversing file. See How to import transactions in General Ledger for steps.
Steps to duplicate
Related Solutions