Hi,
could you please add to the upload statement in back accounts to enable the upload of the gocardless statement output into quickfile.
At the moment it has to be done manually with some editing using a spreadsheet. This could be quite easily done with simple mapping of the gocardless output so it could be uploaded into quickfile:
Here’s the fields in both the gc payouts export and the gc payments export there would be three figures needed to be pulled into quickfile merchant account ready to be tagged one the invoice one the bank charges and one the payment to the bank.
Here’s the fields for the gc payouts export
id amount currency created_at reference status arrival_date transaction_fee_debit transaction_fee_debit transaction_fee_credit app_fee_debit app_fee_credit total_payment_amount links.creditor_bank_account links.creditor surcharge_fee_debit surcharge_fee_credit tax_debit tax_credit
so its the
arrival_date column 7 as date
amount _out column 2 but this needs to be made - (negative)
reference column 5 as description
for the gc charges export the fields are
id created_at charge_date amount description currency status amount_refunded reference transaction_fee payout_date app_fee links.mandate links.creditor links.customer links.payout links.subscription customers.id customers.created_at customers.email customers.given_name customers.family_name customers.company_name customers.address_line1 customers.address_line2 customers.address_line3 customers.city customers.region customers.postal_code customers.country_code customers.language customers.swedish_identity_number customers.active_mandates transaction_fee_tax
so its column 11 payout_date as date
column 23 customers.company_name as description (or id column 1 as this could be tagged with the bill_id in quickfile to pair it with the invoice)
column 10 transaction_fee as amount_out but this needs to be made - (negative)
Can it be possible to put a date range on the import so that duplicates are not created or even better work with gocardless and set up a feed for the merchant account for go cardless?