Batch import of expenses from DLA

Accounting
1

Hello,

I am new to QuickFile and getting started. How do I batch import expenses for my limited company that I have paid for via 2 of my own personal credit cards, and how do I record these using Quickfile’s Chart of Account codes (typically in the Overheads 7000-8999 ranges) automatically in a batch import?

Many thanks for any help you can provide.

2

Hello @HappyDaddy

You could import a csv of the transactions from your credit card statement(s) onto the DLA account

  • Open the DLA account > Options > Upload Statement
  • Choose Other as the bank name
  • Browse the CSV file
  • Map the relevant option
  • Run the upload
  • You can then Tag the transactions

Here are more detailed Instructions
https://support.quickfile.co.uk/t/importing-your-bank-statement/8823

1 Like
3

Thanks - I have a list of my expenses with the VAT rate being applied to each line item and can pre-select the Chart of Accounts line item that they will be assigned to. Is there no way of auto importing these two fields in as well?

4

Hello @HappyDaddy

The previous instructions I gave you would create the purchase records by importing and tagging the payments.

You can do it the other way around, import the purchases and create the payments from them.

Here is the support article
https://support.quickfile.co.uk/t/importing-sales-and-purchase-invoices

On the import you can have 2 additional columns shown below

  • Paid date [For paid invoices if absent the invoice will assume to be unpaid]
  • Paid account nominal code [specify your DLA nominal code]
1 Like
5

Thank you @QFSteve - and if I can finally ask, what should I put into the ‘Supplier Name’ column - for example if I have subsistence costs across multiple retailers. Should I be putting down the retailer name in all circumstances, or should I group them into ‘subsistence provider’ as a supplier? Many thanks once again.

6

Hello @HappyDaddy

Ideally the retailer name in all circumstances but they can be grouped as one supplier as you mentioned (‘subsistence provider’)

1 Like
7

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.