If your bank account statement contains transfers between your own bank accounts there are a few quick steps that need to be done in order to import your statement data after AutoEntry has completed the extraction. This only applies to transfers between your own bank accounts that are set up in Sage 50 and not for transfers externally e.g. paying a supplier/vendor by an electronic funds transfer (EFT).

Essentially, AutoEntry only extracts the statement data as either a payment or receipt. Sage 50 refers to these as a transaction type BP (Bank Payment) or BR (Bank Receipt). A single line transaction as per your bank statement does not suffice for Sage 50 to recognise this as a transfer from one of your accounts to another. A quick edit is required to the export from AutoEntry before uploading to Sage 50.

Once you download the statement data from AutoEntry, open the file as an excel or csv. For each bank transfer either into or out of the account you are working on you need to copy the transaction line, add a line to the sheet and paste the line there and edit the two lines as follows:

The example below shows a transfer from the account as it appeared on the bank statement. We added a row and copied and pasted the transaction into that new row. Edited the payment type to the opposite of the original (BP to BR), added the suspense account to column C on row 2 and in the new row (row 3) added the destination account in column B and the suspense account in column C.

For a transfer in, simply edit the BP line to the account number the transfer came from.