Many articles have been written on how to get accurate cash reports from QuickBooks. In sum, you can’t easily do that. Or you have to change the way you do your accounting – No AR, no AP, etc. Even in a cash-basis company, most people still use invoices and receive bills. It can be very challenging to set up your books in a way that you can get accurate cash reporting.

When you are using Cash Reporting with FinJinni, FinJinni creates a cash-basis General Ledger. The above-mentioned variance reports can be used on a cash basis as well as an accrual basis.

If you see variances, it is usually due to non-cash transactions such as bills and invoices, particularly when billing or invoicing against a balance sheet account. QuickBooks sometimes reports these on a cash GL on the date when they are entered, even if not paid.

You can see the postings that FinJinni uses to balance the QuickBooks and FinJinni reports on a GL detail report with a REF # value “Balance Adjustment”.