We have just completed a migration from QuickBooks Enterprise to QuickBooks Online. I am hoping to find a way to format my QuickBooks Online reports to match my QuickBooks Enterprise reports, showing the remaining balance of an account as a separate "other" line that is then rolled into the total. For example
In QuickBooks Enterprise, the report is represented as:
101-000 Petty Cash | | |
| 101-001 - Petty Cash Events | 1000.00 |
| 101-000 - Petty Cash Other | 1500.00 |
TOTAL 101-000 Petty Cash | | 2500.00 |
In QuickBooks Online, the same report is represented as:
101-000 Petty Cash | | 1500.00 |
| 101-001 Petty Cash Events | 1000.00 |
TOTAL 101-000 Petty Cash | | 2500.00 |
I had initially thought that the "Petty Cash Other" account was listed as a sub-account in QuickBooks Enterprise, but I can confirm that the GL list does not have that sub-account. It just seems to be how the data is represented.
Essentially, I am looking to format my QBO report exactly as my QBE report - representing the "Petty Cash Other" sub-heading, rather than rolling it into line 1 of the account. Is there a way to do this?
*I should specify, that this is specifically affecting my Balance Sheet and Income Statement reports*
Thanks for the help!