Overview
You can run a year-to-date (YTD) income statement directly in Puzzle, with no reformatting in Excel. Choose one total column for the year so far, or monthly columns with a total at the end.
One YTD total column
In the sidebar, open Reports and click Profit & Loss.
Set the date range from Jan 1 of the current year through today.
Set View by to Totals only. You'll see a single column with your year-to-date totals.
To download it, click Export, keep View by set to Totals only, pick your format (PDF, Excel or CSV) and click Export.
Monthly columns with a YTD total
Set the Profit & Loss date range from Jan 1 through today.
Click Export.
Set View by to By Months (or By Quarters).
Set Summary column to Sum Total. This adds a total column at the end of the report.
Pick your format and click Export.
Other export options
Accounting basis: Cash or Accrual
Report level: Compact, Summary or Detailed
Summary column: Sum Total, or Absolute and Percent Change to compare periods
Export options: include account numbers or truncate decimals
For more on exporting with custom dates, see How to Export Financial Statements with Custom Dates in Puzzle.
In Advanced view
Accountants and bookkeepers see Advanced view by default. There, the Profit & Loss is a tab in the Financial Statements section of your Dashboard; the steps are the same from there. To switch views, click View at the bottom of the sidebar.
