We were wondering if there is a way to change the format of the balance sheet and/or profit and loss statement within QuickBooks. For example if a client has several cash accounts can they be combined and printed as one item on the balance sheet?
We were wondering if there is a way to change the format of the balance sheet and/or profit and loss statement within QuickBooks. For example if a client has several cash accounts can they be combined and printed as one item on the balance sheet?
If you use subaccounts, you can click "Collapse" on any report (including the Balance Sheet) and it will show only the master accounts (with amounts rolled up). When you do this you must be careful to always put transactions (Checks, Deposits, etc.) in the particular subaccount (not the master account) that represents the physical bank account. Sometimes a ‘Summary Balance Sheet’ works well in this situation. This report lists one number for each type of account. For example, all ‘Bank’ accounts will be added together and listed as a single number. In the same way all Other Current Assets, Other Current Liabilities, etc. will be listed as a single number. You do not need to use subaccounts for this report to work. However, you cannot modify the headings on the Balance Sheet. If you need to, you can export a balance sheet to a spreadsheet and then modify the headings before printing.