Blog

6
Jul

Sage Intacct with Australian GST

Sage Intacct with Australian GST Sage Intacct now includes an out-of-the-box setup for Australian GST complete with easy to use BAS report preparation, BAS reports and GST Calculation Worksheet. Australian GST is now standard with Sage Intacct and comes complete with all Australian Tax Codes including the standard GST, but also includes Wine Equalisation Tax and Luxury Car Tax. No

Read more

6
Jul

Excel data manipulation using array formulas

Whether we like it or not, there’s always a process, a form, or a report that requires a little bit of manipulation in Excel. We just need to apply one simple operation to use the result elsewhere. But there’s no way to easily do that manually. Often, the issue comes from the source data not having the same number of

Read more

6
Jul

Excel data manipulation using array formulas

Whether we like it or not, there’s always a process, a form, or a report that requires a little bit of manipulation in Excel. We just need to apply one simple operation to use the result elsewhere. But there’s no way to easily do that manually. Often, the issue comes from the source data not having the same number of

Read more

6
Jul

6 best practices when writing reports

We recommend the following six best practices when writing your reports: Use cell references to enter data into formulas. Using cell references in formulas allows the formula to update when the data is changed at a later date, without having to manually edit each formula. This method makes modifying and maintaining your worksheet easier. Use account ranges in your reports to ensure new accounts

Read more

6
Jul

How Licenses are Assigned within Sage Intelligence Reporting

Sage Intelligence Reporting uses a Workstation Licensing model. Almost every Sage solution comes with at least one Report Manager license. That license, and additional licenses you buy, are managed through the License Manager module. The License Manager is a module that is available to all Sage Intelligence users. It allows you to see which users and workstations are consuming Report Manager and Report Viewer licenses and their module configuration.

Read more

6
Jul

Excel Tips and Tricks

How to add bullet points to a field in Excel Using Excel, have you tried to add a bullet point within a field to stack numbers, sentences or phrases?  Adding a bullet point helps the reader to see each point clearly rather than viewing several run-on sentences or numbers.  Here are a few easy steps to add bullets within a

Read more

29
Jun

Sage 300 -GL Provisional Posting

  What if Posting in the GL   Otherwise known as my After Friday at 3pm Posting button!   Provisional posting is temporary posting. If you select this option, General Ledger lets you post transactions to accounts and produce financial reports that include the provisionally posted transactions. At a later time, you can discard or edit provisionally posted transactions if

Read more

23
Jun

What is E-Invoicing and how does it work ?

E-Invoicing (PEPPOL) Currently the ATO is getting ready for E-Invoicing and solutions are being developed now. They expect them to be available in the Australian market in the second half of 2020. A demo is available to view at the ATO website. The current experience is where you go into your software, you generate an invoice from the software, but

Read more

18
Jun

Single Sign On (SSO) for Sage X3

In my previous post we talked about Single Sign On (SSO) and how we can apply it to a Sage 300 installation. In this post I’m going to cover SSO options for Sage X3 specifically the LDAP option. Recapping, Single Sign On (SSO) is the process of centralising the authentication data. The benefits of using SSO is that a user

Read more

18
Jun

Make Audit Preparation a Year-Round Effort

Whether you close the books daily, monthly, quarterly, or just once per year, maintaining up to date auditable financial records is good accounting practice and smart business sense. Regular reconciliation of the bank accounts is critical, but to prove the material accuracy of your financial statements, you should have auditable evidence to support every line item on the balance sheet

Read more