← All docs

Companies not on QuickBooks Online

A company that is not on QuickBooks Online joins Fynease through files: set it up as a CSV / Excel company, then import its data each month. It closes, reconciles, consolidates and reports like any other company; the one difference is that its adjusting entries are posted in its own system, because write-back is to QuickBooks Online only.

The monthly data drop

Drop several files at once. Each is recognised by its columns as a trial balance, general ledger, AR aging, AP aging, budget or customer sales file. You can change what was detected, and a file that is not clear asks you rather than guessing.

The step-by-step importer

Or import one kind at a time: trial balance (which also builds the chart of accounts), chart of accounts, general ledger, AR and AP aging, budget (month columns), and customer sales.

Files and columns

• CSV, XLSX and XLS. Comma, tab and semicolon separators are detected, and Excel files with two header rows (months above, debit and credit below) are read.
• Columns are matched by their names; the importer shows the names it expects.
• A trial balance needs an account name and debit and credit (or balance) columns; the account code is optional.
• A general ledger needs a date, an account and debit and credit (or amount). Optional columns (customer, class, supplier, quantity and price, currency) each unlock more analysis, such as customer revenue or price, volume and mix.
• Ledger rows are placed in their month by date, so one file can hold several months.

Importing again

Re-importing a trial balance offers to replace the period or merge while keeping your overrides. The importer includes export steps for QuickBooks Desktop, Xero and Sage. Imported data is kept permanently, because there is no source system to read it again from.

More in Getting started

• Connecting QuickBooks Online

All docs