Sage is pleased to announce these new features and updates.
Inactive bank accounts
You can now mark unused or closed bank accounts as inactive. This allows you to view accounts by status on the Banking page. Select the Active, Inactive, or All tab at the top right-hand corner of the page to change the view. Inactive accounts are also hidden from selection lists when creating transactions. This prevents the posting of new transactions to the inactive account.
For audit purposes, inactive accounts still show in reports and completed transactions.
Search with less information
Find the contact you're looking for with less information. To make life a little bit easier, enter a contact's address (or partial address), their main or mobile phone number, or just their primary name in the Search field on contact lists to find them quickly.
We've also updated the Search field on the Audit Trail report to search by transaction number so you can quickly track down the history of an entry. This comes in handy when you quickly need to find transactions that show on your VAT returns.
Easily improve your documents
To make document customization easier, we've moved document settings to their own section on the Settings page. With this change, we've also renamed some groups to better explain the settings within.
These are the settings groups in the new section with their old and new names:
|Old name||New name|
|Logo & Document Template||Templates and Logos|
|Email Messages||Document Emails|
|Invoice Form Settings||Document Preferences|
Previously, these settings were located in the Invoice & Business Preferences section, which is renamed to Business Preferences.
Profit and Loss report
When running the Profit and Loss report, you can now choose between the Standard or Comparative versions. The Standard version shows income, expenses, and profit for the current financial year. The Comparative version compares the same information in the current financial year to the previous financial year.
To access these reports, select Reporting, Profit and Loss - Standard or Profit and Loss - Comparative from the main menu. Once a Profit and Loss report is open, select the button if you want to switch to the other version.
Previously, the Profit and Loss - Comparative report displayed when you selected the beta version link from the Standard report.
You can now show up to 100 items by default on list pages (such as Sales Invoices) throughout Accounting. Go to Settings, Navigation and Data Grids, and then select 100 in the Tables of Data section. You can override this setting as needed by selecting a number in the footer of a list page.
It's now easier to set up customer and supplier statements by going to Settings, Statement Settings. Previously, statement settings were located in Record and Transaction Settings.
An issue where the Accounts Receivable Breakdown report showed a paid customer balance as outstanding is now fixed.
Add attachments to your sales transactions
Now it's easy to attach supporting information such as sales brochures, product images, price lists etc. to your sales invoices, credit notes, quotes and estimates.
- Add multiple attachments.
- Make attachments visible to your customers or for internal use only.
- Supports the following file types: PDF, GIF, JPG, JPEG, PNG.
- File size up to 2.5MB.
For more information, see
- When editing a sales invoice, the form now shows the correct amounts for tax rates on product and service lines.
- If a recurring invoice isn't sent, the document timeline no longer shows the status as Sent.
- Active bank feeds will now download transactions after you successfully sign in for re-authentication.
- You can now record sales invoice refunds on tax reconciled payments.
Tax instalment payments
If you pay your GST/HST or QST tax in instalments, you can set default ledger accounts for the payments. When you enter a payment, Accounting will automatically populate the appropriate box on your tax return (110 on a GST/HST return, 210 on a QST return) with the payment amount. As you make more payments through the year, they are added to the total. When you review the tax return, you can adjust the total if needed. This saves you the extra work of tracking your payments elsewhere and manually entering them on your tax returns.
See Setting up taxes for more information.
We’ve made these great improvements to the Trial Balance report:
- As of option. You can now run the report “as of” a specific date to get a snapshot of what your ledger account balances were on that date. The report will show data from the start of each account up to the selected date.
- Zero balance accounts option. The new Hide accounts with zero balances option allows you to hide (or show) zero balance ledger accounts on the report.
Unused ledger accounts are never included on the Trial Balance report.
- Retained Earnings breakdown. If you select Summarize retained earnings values, a Retained Earnings line is included on the report. You can now expand the row to see a breakdown of how the summarized amount was calculated. The report splits out the system calculated Profit and Loss values and manual postings to the Retained Earnings account.
For more information, see About the Trial Balance report.
- A duplication issue that sometimes occurred when voiding cheques has been fixed.
- An issue where some reports got stuck during the calculation process has been fixed.
- An error no longer occurs when you click Banking with the language set to French.
The Trial Balance report now updates as expected after creating credit notes.
- When creating journal entries, you can now mark Include on tax return if you want to include the line amount on your tax return. See How journal entries affect the tax return for more information.
- You can now enter purchase transactions and other payments for provinces that include GST & PST if you don't have a PST number. This ensures that the PST you’ve been charged is calculated on the transactions.
- The image validation process has been improved when you upload your business or association logos.
The General Index of Financial Information (GIFI) is a list of codes defined by the Government of Canada that corporations must use when preparing financial statements. This information is required when corporations file their T2 returns to the Canada Revenue Agency.
Goodbye to spreadsheets
GIFI codes are now included in the default chart of accounts in Accounting. If you are setting up a new business, the codes automatically show in the GIFI Code column on the Chart of Accounts page (go to Settings, Chart of Accounts). If you are using custom codes, click the ledger account to open the Edit Ledger Account window where you can edit the code. Alternately, you can also import a chart of accounts that includes GIFI codes.
If you have an existing business, you now have a way to enter GIFI codes. Go to Settings, Chart of Accounts and then click a ledger account to open the Edit Ledger Account window. Enter the code in the GIFI Code field and then save the account. You need to do this only once to automatically include GIFI codes in all of your future financial reports.
Reporting with GIFI codes
With GIFI codes in your chart of accounts, you can show (or hide, if your business is unincorporated) them on the Trial Balance report. Go to Reporting, Trial Balance, and then use the Show GIFI codes option to show or hide them.
From the Trial Balance report page, you can also export a GIFI file. This is helpful if you are using a third-party application for analytics or compliance. Click Export, GIFI to create an *.gfi file in your computer's downloads folder.
You can now transfer funds between two Cash bank accounts.
The report headings on the Trail Balance report are now included on all pages when you print to PDF.
- The report headings on the Aged Debtors
and Aged Creditorsreport sare now included on all pages when you print to PDF.
The top of the second page of sale invoices is no longer cut-off when printed.
- Accounting now gives you the option to create invoices for any missed recurrences after you resolve an “Action Required” recurring invoice.
- Names and references are now included on all pages of customer and vendor statement PDFs.
- If you need to reset your data, any recurring invoices you have are automatically paused.
The Trial Balance report no longer fails to print to a PDF if it includes forward balances.
- Invoices with a balance of zero no longer display as overdue.
You can now view (but not edit) completed recurring sales invoices.
Accounting now prevents you from voiding reconciled cheques.
Recurring sales invoices
Do you regularly enter the same invoices? For example, customers to whom you regularly sell the same products or services your business regularly sells. End the drudgery of manual entry, save time, and reduce errors by setting up recurring invoices.
You can set a new invoice as recurring or update an existing invoice to reoccur. Create (or edit) a sales invoice as you normally would and then mark it as recurring to choose the repetition frequency. You can then pause the recurrence as needed or copy the recurring invoice to use it as a template when creating another recurring invoice.
See About recurring sales invoices for more information.
Eliminate the need to manually input your data. AutoEntry is a cloud-based application where you capture your invoices, expenses, receipts, and statements and then upload them to Accounting.
See Set up AutoEntry to get started.
Partially recoverable ITCs/ITRs
The Receipts and Payments Day Book report
The Receipts and Payments Day Book report now indicates tax amounts that include partially recoverable ITCs/ITRs. You can use this report to help ensure that your transactions are entered correctly and to reconcile your tax returns.
All expense transactions have now been updated to allow for, or to ensure correct accounting of partially recoverable taxes. This includes:
- Vendor Bills
- Vendor Credit Notes
- Other Payments
- Expense Other Receipts
- Quick Entry Vendor Bills
- Quick Entry Vendor Credit Notes
- Import of Expense Quick Entry bills or credit notes (that include a ledger account configured for partially reclaimable tax)
Sales and expense invoices are now calculated the same when GST/QST taxes are included for contacts in Quebec.
New tax rates have been added for the sale of vaping products in British Columbia (BC):
- PST 20%
- PST & GST 25%
You can select the new rates for line items on all sales documents (invoices, credit notes, quotes, Quick Entries, estimates, and other receipts).
If your business address is in BC, you can select the new rates on all expense documents (invoices, credit notes, Quick Entries, and other payments).
Where GST is charged on vaping products, the GST % is calculated on the net value plus PST calculated. For example, with a net value of $1000, the calculation is 1000 + 20% PST = 1200 × 5% GST = $60. This method is different to other rates available, where GST is based on net value before calculation of PST.
The following sales tax and payment reports will also show the new BC tax rates:
- Canadian Revenue (CRA)
- Provincial Sales Tax (for BC)
- Sales Day Book
- Expense Day Book
- General Ledger
- Tax Returns
- If you change the province of your business address, other payments/receipts now show the updated province.
- Paid tax returns no longer display as part paid.
- A “tax rates updated” confirmation message no longer displays when you create new invoices.
- Columns in the Detailed Tax return are no longer cut-off when you export it to a PDF.