# Can I use a ProfitDrawer spreadsheet for more than one year?

Yes. You pay once and the file is yours to keep and use every year. A ProfitDrawer bookkeeping spreadsheet covers one financial year at a time, set on the Settings tab, with room for 1,000 income rows, 1,000 expense rows and 500 trips. For a new year, save a copy of the file, change Financial year (starting), for example to 2027, and clear last year's rows. The old file stays as your record for that year.

**Starting a new year:**

1. **Keep last year's file as it is.** Rename it, for example "Books 2026". It is your record, and tax records are generally kept for 3 years after filing.
2. **Make the new copy:** in Excel use File > Save As; in Google Sheets use File > Make a copy. Name it "Books 2027".
3. **Open Settings** in the new copy and change **Financial year (starting)**. Check the **mileage rate**, since the IRS rate changes, and update your **profit goal**.
4. **Clear the old rows** on Income, Expenses and Mileage (select from the Date column across and press Delete). The formulas in the shaded columns stay.
5. **Carry over unpaid invoices** by re-entering any still unpaid, so they stay on the Unpaid Invoices tab.

Why one file per year: the dashboards and totals only count rows dated inside the financial year on Settings, so a mixed file would leave older rows out of the totals anyway.

The financial year can start in any month, so a July to June year works the same way.

- Source: [ProfitDrawer FAQ](https://profitdrawer.com/faq.html)
- Updated: 2026-10-29
- Published: 2026-10-29
- Category: About ProfitDrawer files
- Canonical: https://profitdrawer.com/answers/can-i-use-a-profitdrawer-spreadsheet-for-more-than-one-year.html
- Publisher: ProfitDrawer (https://profitdrawer.com)