Report of transactions through our company credit card

Question

I need a report of any transactions through our company credit card. We have 15 users with individual cards all together on one master credit card bill. I keep the transactions separate for each user to enable better visibility and easier reconciliation, but I would like to run a report that covers more than one account and includes Bank Payments and Supplier Payments. (and receipts in the case of any refunds or credits on the cards). 
 Even if I can find one report that includes all transactions for a date range, I would be happier though it would be a pain to run it 15 times each month. 
 Thanks

Steven Holden · Accepted Answer

Thanks. That could work. Except the report output includes nominal codes/Bank Accounts that are marked as "Closed". And unfortunately, my accounts are not in order as some could be closed; some are cash accounts etc. It would be ideal to run the report from the Bank module where I can highlight the accounts I need, or run a search query to select the accounts. 
 But of course I can edit the nominal report and insert a query in there to exclude certain accounts or phrases in the account description so I will make it work. 
 Thanks

Steven Holden · Answer

Hi, 
 
You can run the Nominal Activity report for all of your Credit Card Accounts via Nominal Codes > Reports > Nominal Activity. 
 
The criteria screen in here will allow you to choose a range of codes and will then run to display all transactions posted to the Credit Card accounts. 
 
Kind Regards, 
 
Adam 
Sage UK

Sage 50 Accounts

Report of transactions through our company credit card

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING