Reference a single account code in calculations
Learn how to use the ACC function to build calculations that reference individual accounts in a Financial Statements statement. For example, you can add gross profit and gross profit percent for online sales only, so you can compare different sales channels and cost of sales channels.
Supporting documentation
Related video tutorials
Map accounts to a group
Learn how to map accounts to groups in Financial Statements so each account appears in the correct section of your statement. You'll search, filter, and sort the account list, map several accounts at once, hide mapped accounts, and rebuild the database to apply your changes.
Set up your Trial Balance statement
Learn how to set a financial year end date so your Trial Balance shows the right closing balances. Profit and Loss accounts show the balance since the start of the year, while retained earnings exclude current-year movements. You can also add levels or column groups to see each trading entity.
Edit a financial statement
Learn how to edit a financial statement so its layout and formatting match your reporting needs. You'll add groups and calculations such as gross margin, arrange rows, apply formatting and performance indicators, choose the revenue row for percent revenue analysis, and build the database so your changes take effect.
Create a budget from within financial statements
Learn how to create a profit and loss budget directly from your financial statement with one click budgeting, available with the Budgets and Forecasts module. You'll set up the statement levels, create the budget, and open a workbook that reflects your setup, which cuts setup time and keeps both modules aligned.