FinJinni Reporting on QuickBooks Reimbursed Expenses

If you use the reimbursed expense feature in QuickBooks, Invoices can be created without the Item field filled in on the line items. FinJinni normally requires this field to identify the associated account. QuickBooks does not provide the account to third-party applications if the item field is not filled in.

To show the proper account balances for reimbursed expenses, FinJinni normally uses the daily trial balance to identify the total of reimbursed expenses for each account and day.

If you want a finer level of detail, FinJinni can use an expense report from QuickBooks to fill in the additional information and report each reimbursed expense line. The company setup option “Track Individual Reimbursed Expenses on Invoices” must be checked for this to be done.

When using QuickBooks reports to obtain additional information, it is important to use distinct account names. If you have multiple accounts with the same name, they appear the same on QuickBooks reports, even if they have different parent accounts. For example, if you have accounts “Homeowners:Insurance” and “Auto:Insurance”, they both appear as “Insurance”. FinJinni cannot tell which account is being used on an individual expense line.

Another way to handle these accounts is to use an account description and set the QuickBooks preference “Name and Description” under Reports & Graphs Settings, “Show Accounts By”. The account name and description will both appear on reports, e.g. “Insurance (Auto)” if the account description is set to “Auto”.