Download data from one bank account and include Nominal code

Support
1

I have three bank accounts on Quickfile. I want to download (preferable as CVS) the transactions from only one and include the Nominal code I have tagged each transaction as. How do I do this? Thank you.

2

Hello @Open-Authorisation

As I mentioned in my previous email, this is not possible as 1 payment could be paying off multiple invoices with multiple nominal codes.

3

There must be some way to do it so that each transaction lists multiple codes then. My accountant is wanting everything in excel format and not being able to do this kind of makes quickfile useless. As after I downloaded the data it would take longer to arrange it into columns that is I just directly download from my bank and PayPal.

4

Hello @Open-Authorisation

>As after I downloaded the data it would take longer to arrange it into columns that is I just directly download from my bank and PayPal.

The nominal codes are not stored on the payments/receipts, they are on the associated invoices.

As I mentioned

You may be able to put something together by looking at the Sales > View Payments and Purchases View Payments exports (filtered by bank) then cross reference with the Sales > Invoice Item Data and Purchase Invoice Item data but its not going to be an easy task as

  • 1 invoice (possibly with multiple nominal codes) may have many payments
  • 1 payment may pay many invoices (possibly with multiple nominal codes)

You could just create a user for you accountant in the Team Management screen and give them access to the data to get what they need.