Create a quarterly financial statement for a monthly client
You can create quarterly reports for your monthly clients. This helps you present data in a way that's more useful for certain types of analysis or reporting.
Follow these steps to create a quarterly report for a client who reports monthly.
- SelectFile, thenReport Designer.
- Double-click a financial statement to open it.
- Save a backup (recommended):
- SelectFile, thenSave As.
- Give your report a new name.
- Set up quarterly columns:
- Select the 1st column you want to make quarterly.noteUse SHIFT+click to select multiple columns at once.
- In the Column Properties section of the Design Tools frame, change the period to[(CP-2) + (CP-1) + (CP)]. This combines the current and prior 2 periods.noteFor prior-year quarterly, use[(1PP-2) + (1PP-1) + (1PP)].
- Create quarterly headers:
- Select the cell with the column header.
- In the Cell Properties section of the Design Tools frame:
- Change the contents to[Client.AccountingProcessing.Periods.MonthsinQuartertoDate] Ended.
- Change the period toCP.
noteFor prior-year headers, use the same content but change the period to1PP. - SelectFile, thenSave Asto save your changes.noteYou can selectFile, thenRestore Defaultto restore the original report.