Help with manually importing bank transactions (not bank feed)

Question

I am about to import hundreds of bank transactions to my Nominal ledger using a Journal Import Template. (Audit Trail template) 
 My question is what do I put in the Type column for the bank transactions? The BP will identify the debits in the expense nominal codes but what do I use in the Bank nominal code line to show the credit? 
 General Journals register the debit as JD and credits as JC - should I just treat the whole transaction as a general journal?

Heather Mo · Accepted Answer

This is not a Bank Feed question, I'm sure if the accounts were linked to the bank this situation would not have arisen. 
 The Journal Import Template cannot be used for BP and BR journal types because they are reserved journal types that post automatically to the bank control accounts in Sage. My issue was resolved by using JD and JC in the import file. 
 The Journal Import Template posts a general journal that needs all debits and credits to be specified.

Andy Rickeard · Answer

Hi Heather, Thanks for using Sage City. In terms of importing bank transactions, you're right you can use 'BP' for Bank Payments out of your bank account and you can use 'BR' Bank Receipts for money arriving in your bank account. Alternatively, again as you suggest you can use Journal transactions JC - Journal Credit and JD - Journal Debit. The following article explains the transaction types that can be imported: Data fields you can import > If this answer has helped, please click More > Verify Answer . 
 Regards, 
 Andy 
 Sage UK

Sage 50 Accounts

Help with manually importing bank transactions (not bank feed)

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING