Puchase Import

[ProdExch]

I’d like to import all my purchases from a csv file but can’t find a way of importing more than one line. I’m being offered a Total Gross Amount field to map but need to break that down into amounts posted to different nominal codes. Is this possible?

[QFMathew]

Hi @ProdExch

Unfortunately the import only supports single line invoices so it would only be to one nominal code.

Are you able to tell us a bit more about your situation and perhaps we can advise on a better way to handle this? For example, where is the CSV file coming from?

[ProdExch]

We are a theatre agency representing actors and I generate a weekly Google Sheet which details payments to clients in a number of ways, each to a relevant and distinct nominal code:

Fees usually without VAT
Subsistence Payments always without VAT
Travel Payments always without VAT
Deductions for Pension Payments always without VAT
Deductions for our Commission always with VAT.

from this sheet I generate payment advice slips to the clients. I’d love to be able to import all the info from the sheet but at the moment I’m inputting the information manually

Thanks

[ian_roberts]

I’ve had some success scripting the QuickFile API from Google Apps Script in a sheets add on. In my case it was to upload files from Google Drive to the receipt hub but I’m sure that for someone with the right expertise it’s be fairly straightforward to use the API to create a multi line purchase from a google sheet. If this is something you fancy having a go at then feel free to lift the authentication code from my google drive connector (search the forum for the link).