Year end Sage accounting: Sage 50 close and trial balance

Find out which Sage the client is on

The steps in this guide come from Sage's Sage 50 US help and knowledge base pages. Sage 50 is the desktop product. Sage Accounting, the cloud product, has its own year-end screens, and I could not open a current US help page for it, so its menu names are not given here. Confirm the product and version with the client before you follow any step.

Edition matters in Sage 50. Sage's help says the Internal Accounting Review is available in Sage 50 Premium Accounting and higher, and the Excel report layout options are also listed for Premium and higher. A Pro user will see a shorter wizard and fewer export choices, so check the edition in the first call with the client.

Clear the blockers before the wizard

The Year-End Wizard is single-user. Have every other user close the company before you start, or the close will not have the file to itself.

Resolve any purchase invoices marked Waiting on Bill, or the wizard will not proceed. Go to Lists, Vendors & Purchases, Purchases. Set Date Range to All Transactions, click Waiting On Bill twice, then open each invoice, clear the Waiting on bill checkbox, add an invoice number if it is missing, and save. In a large database, work through one period at a time.

Enter every adjusting entry before the close. Sage's notes say financial statements and most General Ledger reports can still be printed for a closed year, but forms and most other reports cannot. Print anything you will need later while the year is still open.

If the company uses batch posting, post and print all journals, print the Yearly General Ledger report, and print open invoices and vendor and payroll checks first. In batch mode the close will not proceed until all transactions are posted.

Run the Year-End Wizard in order

Open Tasks, System, Year-End Wizard. The first screen shows the two open fiscal and payroll years. Click Next. On the Years to Close screen, Sage says to choose Fiscal and Payroll Tax Years when the fiscal year matches the calendar year. If the two years differ, close Fiscal Year only or Payroll Tax Year only and run the wizard once for each.

On the report screen, check each year-end report you want printed. The Internal Accounting Review is optional and runs from one button, and it is worth running on a file you expect to close cleanly. Then continue to the backup step.

At the backup step, click Back Up, set the options, click Back Up again, click Save, and click OK on the size message. Click Next when the backup finishes. Keep that file until the preparer has the return. I would not delete it after the close, because it is the only way back if the close fails.

The New Open Fiscal Years screen lets you change the period dates for the next year. Sage 50 adjusts those dates automatically, and the knowledge base advises against changing them unless your accountant directs it. On the Confirm screen, check which year closes and which year stays open. Leave Run Data Verification checked, which Sage recommends, and click Begin Close. When the results window appears, click Finish. Confirm the result under Tasks, System, Change Accounting Period.

What the close locks and when to run it

Sage 50 keeps two fiscal years open at once. Period 13 starts the second open year and period 24 ends it. Sage suggests closing the first fiscal year typically around the 22nd or 23rd period, which leaves time for corrections before the next year is in use.

Sage highly recommends waiting until the prior year's tax returns are sent before you close the fiscal year. Make any adjusting entries in the last accounting period first, then close. The close is the lock, so do it after the preparer has signed off on the numbers.

For payroll, wait to close the first payroll year until all payroll reports, W-2 data and 1099 data are final. Sage also says to wait until the tax returns for that year are complete. A W-2 that changes after the payroll year closes is harder to correct than one that changes before.

Closing a year does not delete its data. Sage notes that the wizard leaves old data in place and recommends purging when the file passes roughly 300 MB. To check the size, go to Help, Customer Support and Service, File Statistics, and read the Grand Total.

Export the trial balance for the preparer

Export before you click Begin Close. Open Reports and Forms, select the trial balance, set the date and options, and click the Excel toolbar button. Choose Create a new Microsoft Excel workbook, or Add a new worksheet to an existing Microsoft workbook and browse to the file. Click OK. Sage opens Excel with the data on a worksheet named after the report. Sage's help requires Microsoft Excel 2003 or later.

Pick the layout on purpose. Sage 50 report layout keeps the report's formatting, which suits a preparer who reads the sheet. Raw data layout exports unformatted rows and columns, which suits a preparer who will sort, filter or load the numbers into a workpaper. Auto-filter is available only with the raw data layout, so choose it if the preparer will filter by account.

Use the header options to match the workpaper. Show header in Excel worksheet puts the company name and period on the sheet, which helps when the file is printed or saved alone. Send header to Page Setup keeps the sheet clean and moves the header into print settings.

A practical pack for the preparer is four files, each saved with the client name and year: the trial balance for the closing year, the balance sheet, the income statement, and the Yearly General Ledger report. Name them the same way every year, for example Acme Plumbing 2026 trial balance pre-close, so the files sort together. If the preparer sends corrections back, Sage's help says to use the Import facility to bring Excel data into Sage 50.

Failure modes and the fix for each

The wizard will not start or stops at the Waiting on Bill step. Clear the flagged purchases as described above, then run the wizard again from the start. Do not edit the period dates to get past the block.

A warning says there are unprinted items. Close the wizard and print them, or click Next to continue if they are not needed. Unprinted transactions that have no reference number can still be printed after the close, according to Sage's notes.

The close was interrupted. Sage says that once the close begins it cannot be stopped, and an interrupted close can damage data. Restore the backup from the backup step, then run the wizard again. This is the reason the backup is not optional.

The preparer asks for a closed-year report after the close. Forms and most reports cannot be printed for a closed year, and financial statements and most General Ledger reports are the exception. Test the report you need before the close. If it is not on the list, export it while the year is open.

The fiscal and payroll years differ. Close each year separately, starting with the fiscal year once the return is out, and check Tasks, System, Change Accounting Period afterward to confirm which years are open.

Sage Accounting in the cloud

The cloud product stores its year-end and lock settings differently from Sage 50, and this guide does not give those menu names because I did not verify them on a current US page. Ask the client to open the company settings and find the year-end or lock date field, then check the date against the prior year's close notes before anyone posts into the locked period.