Dowloading Ebay and Amazon sales directly into Quick File

[ian_roberts]

The documentation on how to import invoices from CSV is here:

Importing sales and purchase invoices

Introduction If you have a spreadsheet containing sales or purchase invoices, you can import these into QuickFile from the Data Import Wizard (accessible from account settings). QuickFile will automatically try to match the client or supplier to any existing records or create new ones when no match is found. A maximum of 250 invoices can be imported at one time. Here’s how to import sales and purchase invoices in QuickFile From your dashboard click on the account settings menu item then click…

Once you know which columns are which in the Amazon/eBay download then what you’d basically have to do is

1. Open the downloaded CSV in excel/google sheets/etc
2. Add a second sheet to the workbook
3. Put the right column headers for QuickFile into row 1 (see the article above)
4. In row 2 put fixed values for things like the client name (“Amazon sales”), the last day of the month for the issue and payment dates, and then for the gross and VAT amount columns put =SUM(Sheet1!C2:C1048576) for the appropriate columns from the downloaded sheet.
5. Save this second sheet as CSV and upload it into QuickFile

Once you’ve worked out the columns once you should be able to save a template with a blank sheet for the Amazon CSV and with the QuickFile sheet pre populated, then all you need to do each month is copy the template workbook, import that month’s CSV into the blank sheet, then export and upload the other sheet.

You can get more creative with your formulas to automatically calculate things like the date (latest transaction date from the Amazon sheet) and description (e.g. ="Sales for " & YEAR(A2) & "-" & MONTH(A2))