import excel files

david's Avatar

david

12 Apr, 2021 04:44 PM

uploading transaction from quickbooks

  1. 1 Posted by dwg on 12 Apr, 2021 10:10 PM

    dwg's Avatar

    I'm a fellow user.

    Importing excel data and importing from Quickbooks are very different propositions.

    Starting with Excel, you would save a CSV file as Moneydance can import tables into Non-investment accounts and a CSV file is basically a table.

    The CSV file must have a consistent format however, each row is a record and all fields are present and in the same place in each record, with CSV files this would usually mean data is present or a comma is there to indicate no data. I do not believe it would work with a transaction spread across lines.

    Quickbooks is a problem, it does not output to QIF files which is the preference, it only supports IIF format which does not export journal entries.

    Quickbooks does create reports which can be printed to a file selecting the Excel file type, thus you can potentially get a CSV file, but how useful this file is depends on the format, it may be suitably structured or the data may need manipulation to get it into a viable structure. I have never seen a file from Quickbooks to be able to make a judgement call on this.

    With CSV files in generally you have a few options, there is the inbuilt importer, there is a user written importer which has more options or you can use a macro in Excel to create a QIF file from the data. The viability and suitability of any of these depends entirely on the data structure.

  2. System closed this discussion on 12 Jul, 2021 10:20 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac