Skip to main content

Attaché Accounts: Delete a batch in General Ledger

Updated over a month ago

The only way to fully delete a batch in General Ledger is to perform an End of Year. However, you can remove the transactions from the batch to make it an empty batch.

You may need to delete a batch, for example, if a batch was duplicated in error and caused the addition of a very large number of transactions to your Bank Reconciliation Unreconciled list. To remove these transactions, you'd need to reverse the batch and then reconcile all the incorrect entries as well as the reversals which could take a very long time. Deletion may be faster and so a full audit trail may not be as important to you.

Only use this process with extreme care. And keep in mind that your business may have relevant audit requirements that would question deleted/empty batches. Be sure to take an Archive of your dataset before starting.



Delete all transactions in a General Ledger journal batch

To delete all transactions from a batch you can either:

  • Delete them manually. To do this simply go to the relevant menu item and use F6 Delete at each transaction within the GL batch.

  • Use a KFI to automate the above procedure for large batches. A KFI template file is available here.



Using the KFI method

To use the KFI method do the following:

  1. Archive Attaché (very important).

  2. Go to the relevant menu item, for example, if the batch is a Journals-Other Modules batch, go to General Ledger, Transactions, Other Modules, Journals from Other Modules.

  3. Select the Batch No to delete.

  4. Press Accept F9 to move to the next screen.

  5. The transaction entry screen will default to display the next transaction number in the batch, so if the Number is 110, then there are 109 transactions in the batch.

  6. Use the KFI template at the above link to enter 109 in cell B1 (highlighted in yellow).

    📌Note: if your batch has more than 500 transactions in it, you will need to copy and paste more lines from row 501 up.

  7. Copy the KFI commands in Column D from row 1 until Column B equals 1 to a new text file in Notepad. In our example this would be row 1 (B1 = 109) to row 109 (B109 = 1, meaning transaction 1 in the batch).

  8. Select File, Save As in Notepad.

  9. Change Save as type to All Files.

  10. Enter a name like: DeleteBatch50.kfi

    • The file name can be what you like.

    • the ".kfi" extension is required.

  11. Back in Attaché, go to the batch you had open at Step 3.

  12. Select File, Keystroke File Import or click the KFI button.

  13. Use File (F2) to select the kfi file you saved at Step 8.

  14. Select Start (F5) to start the KFI. The KFI will go to each transaction in your batch and use Delete F6 to delete it.

  15. When the KFI finishes Total Debits and Total Credits for the batch should equal zero. If not select List F4 to view remaining transactions in the batch.

  16. If there are still transactions in the batch, select the last one in the list and delete them as well. You can delete them manually or create another KFI if necessary.

  17. Once all transactions have been deleted from the batch select Finish ESC to close the batch.

Did this answer your question?