Tutorial Series: Accounts Receivables Allocations Inquiry

Accounts Receivables Allocations Inquiry in SapphireOne

Allocations Inquiry is similar to Transactions Inquiry. However, it does not display all current transactions but only those that have not yet been fully allocated.


Whenever a transaction is created, the system determines automatically whether an allocation has to be made. In the Allocations Inquiry window, the transactions are displayed according to the Client for whom the Transaction has been created.

The main purpose of this Allocations Inquiry window is to be able to allocate any Receivables Transactions for which payments have now been made but have not been allocated, for example a Client Receipt can be allocated from here against the appropriate Invoices.


Allocating Transaction in SapphireOne

From here you can also unallocate transactions in order to be able to delete or re-allocate. However, you can only delete transactions as long as they are still unposted. Once a transaction has been posted, it cannot be deleted anymore, but note that it can still be allocated or unallocated.

Open Item Clients Window

Here you can allocate selected Client Receipts or Client Credits to any other transactions for the selected Client.

Here you can allocate selected Client Receipts or Client Credits to any other transactions for the selected Client.

  • Manually click on any line in order to fully allocate it OR
  • Right click on any line to partially allocate it [>] Opens an Allocation Amounts Window OR
  • Select from the “Apply To” drop-down for an automatic allocation of all transactions in the Allocation Lines

To unallocate a transaction either:

  • 1. Manually click on any line that has already been allocated to fully unallocated it OR
  • 2. Right click on any line to partially unallocate it [>] Opens an Allocation Amounts Window OR


SapphireOne covers ERP, CRM, DMS and Business Accounting is an all-in-one integrated software solution. If you would like to find out more about our Accounts Receivables Allocations Inquiry and Transactions Inquiry, request a live demo with us here.

The Accounts Receivables Transactions Inquiry in our Business Accounting Software

The Accounts Receivables Transactions Inquiry in our Business Accounting Software


The Receivables Inquiry functionality in SapphireOne contains all types of transactions that could potentially be involved with generating income via client relationships.


There are four Inquiry windows in Receivables.

The first one is Transactions Inquiry, which allows you to search for, view and also edit all current client records (Money Receipts, Client Invoices etc.)

It displays a list of all current transactions, which are by default sorted in ascending order by their entry date. You can change the sort order by simply clicking on any of the column headings.

The Inquiry Toolbar

This toolbar is almost identical for all Inquiry windows regardless of the Mode you are in and it also includes shortcuts that are linked to:

  • All Inquiries

  • All Data Entry

  • Reports (to export Reports or create Dashboards)

    1. The “Add New” button is not displayed here as the transactions have to be entered through their respective menu items (e.g. Client Receipt).
    2. The “Delete” button is only displayed when unposted and unallocated transactions are selected.

If you want to delete an allocated but unposted transaction, you need to unallocate it first.

A posted transaction cannot be deleted anymore, however, it can still be allocated or unallocated.

Once a Receivables Transaction has been posted, allocated, reconciled and included in the BAS and once Month End has been rolled (so that the entry date is not in the current period anymore), it will disappear from this window and can now be found in History Transactions.

How to Allocate, Unallocate and Post Transactions

How to Allocate, Unallocate and Post Transactions


  • To fully allocate, choose the transaction or multiple transactions, click on [Tools] and either:
    1. Allocation – Open Item Clients Window
    2. Allocate to 100%

  • To unallocate, choose the transaction or multiple transactions, click on [Tools] and either:
    1. Allocation – Open Item Clients Window
    2. Allocate to 0%

  • To post, choose the transaction or multiple transactions, click on [Tools], then Post Transactions.

SapphireOne offers an outstanding Business Accounting Software for medium- and large-scale companies. For more information on how our Accounts Receivables Transactions Inquiry, please request a live demo. You can also find testimonials from our long-standing clients on our website.

Why it is critical that every change in your ERP System is tracked

Keeping track of every change in SapphireOne

The need to be able to track specific changes that are made within your ERP solution is crucial to successfully identify and resolve critical issues that may arise within your business as soon as possible. Without this capability available in your business, you could find it extremely difficult to keep tabs on changes made within your ERP system.

Resolving any critical issues straight away

From an operational standpoint, gaining accurate financials means you need to track these basic variations, which is where revision change orders or tracking or versioning come into play. In Project Management Body of Knowledge (PMBOK) version control has a significant role for managing a project effectively. Version control is a method of tracking changes to documents and files so that you always know which version is the current iteration. It also enables you to maintain old versions in case you want to see what’s changed or need to restore a previous version. Projects typically result in the creation of a lot of documents, from project reports to deliverables. By using project management software with version control, or version management, you can effectively and efficiently track and control changes to these documents directly within your software. Just like version controlling, within your ERP system if there is some sort of change or activity tracking feature enabled, then you will be able to resolve any critical issues straight away.

Today’s IT executives have more choices than ever when choosing an Enterprise Resource Planning (ERP) solution. From on-premises systems to cloud-based software-as-a-service to industry-based solutions, there is a dazzling array. And decision makers can feel overwhelmed when trying to determine which features and functions are the most important. You may find some useful information from our blog regarding this topic – ‘On Premise ERP vs Cloud ERP | Which solution is more resilient and sustainable for your business’

When implementing an ERP system, many organisations focus their time and effort on gaining approval from leadership executives, when they should be engaging key employees who will be using the system the most. We frequently conduct surveys with our clients on our SapphireOne features and functions that they like most. One client has mentioned that tracking any changes made to a vendor, such as changes of address, payment terms, banking details with system date and time stamp, helped them immensely and saved them valuable time.

The importance of tracking any changes made

To illustrate the importance of tracking changes in the SapphireOne system, let’s look at some all-too-common scenarios that tend to happen when a tracking feature is absent.

Scenario 1 :  You get updated credit card information from a client and make changes to banking details, only to find out you updated the wrong client banking details.

Scenario 2 :  John is one of your regular clients and you send him deliveries frequently. But today you have sent a delivery to the wrong address and you don’t know who changed the address.

Scenario 3 : You use Cash On Delivery (COD)  as payment terms for making payments and suddenly it has changed to prepaid. You have no record when it was changed.

The risk of changing the wrong client or vendor details is extremely high when you have thousands of  clients and vendors, or you are multi-tasking or continuously working for long periods of time. If the ERP system is used by multiple users, then it is essential that you track every change made by each user. But if the system does not allow it, then you will be wasting time, creating extra work, and increasing the risk of errors being included in the final product. A more serious change error could be a schema change to your ERP system that means that your whole business loses critical access. After these issues are raised, it is crucial to be able to resolve them straight away to mitigate the impact that it could have on your business.

Tracking any changes made to a vendors address, payment terms and banking details

SapphireOne has the ability to track specific changes that you make in SapphireOne. With SapphireOne it is so much easier to be able to find and fix errors or to even spot any fraudulent activity. When tracking capability is in place, it gives you the opportunity to review before and after values which enables you to correct any issues once you have located them.

When you make any changes to vendors or clients addresses, payment terms or banking details, SapphireOne keeps a log entry for every activity.

To view the record of changes made in address, payment terms or banking details go to :

For Client – Account > Receivables > Clients [modify ] > Details [ Terms]

For Vendor – Account > Payable > Vendor [modify] > Details [ Terms]

For Client go to Account  Receivables and then Clients
For Vendor go to Account  payables and then Vendors

If you have wrongly changed the banking details then you can review before and after values by going to Utilities > History > History of Bank Changes

History of Bank Changes

Improving your track specific changes that you make within your ERP solution, is just one of many reasons to consider a new ERP system. If you’d like to discuss ERP functionality of SapphireOne and want to explore its features, then send a demo request to set up a time.

Accounts Receivable Alerts ensures prompt payments

No one likes having money owed, it’s important to stay on top of your customer invoices. Businesses can prioritise sales and fall into the trap of extending credit to customers, offering discounts or ignoring payment terms if it means winning new sales. Regardless of how many sales your company makes, this becomes meaningless if you are not being paid on time. Not getting paid can lead to cash flow issues which can impact your ability to pay vendor bills, meet payroll or other obligations. You need to consider customers are sometimes not respectful or just forgetful in paying invoices, so keeping track of payment dates, when invoices are sent and due is fundamental. Accounts receivable alerts helps you stay in control of your invoicing.

SapphireOne Workflow with Accounts Receivable Alerts Enables Friendly Reminders to Employees and Customers

Collection efforts should be consistent and methodical. When processes are automated as much as possible you reduce the risk of errors from manual entry.

In SapphireOne ERP you can set up a workflow of alerts for ageing receivables. These accounts receivable alerts can be emailed to your relevant employees when the balance is near, due or outstanding. Friendly reminder emails can also be scheduled to your customers. You can create unlimited workflows with credit control reminders in SapphireOne.   

Best email practices when asking for payments 

It is always a good practice to set up an initial reminder one week before the Invoice Due Date. Keep it polite and in your Email Subject mention it is a follow up on the invoice #. The body of the email should be short, friendly and informative. This will also advise customers that you are on top of your invoices.

The next email should be created on the Day the Payment is due. In your Email Subject mention the invoice # and that it is due today. Keep it short and friendly and mention it is a reminder as technically the customers are not late in paying. 

When the payment is overdue, and depending on your credit terms, you can send a more direct email. In the subject let them know which invoice is overdue and by how long. Ask for payment, list payment methods, and let them know what will happen to their account if not paid in time.

Click for more information regarding improvements and features within the latest release of SapphireOne ERP, CRM, DMS and Business Accounting Application. Alternatively, contact our office on (02) 8362 4500 or request a demo.

How to set up your workflow in SapphireOne

Why do your organisation needs ERP accounting software?

SapphireOne ERP Accounting software is designed to help companies introduce accounting accuracy to achieve peak financial performance

It is vital for managing all financial aspects of your day to day business activities.

You can perform basic accounting tasks such as generating financial reports, invoicing, tracking income and expenses. Accounting software manages your financial data and analyses sales performance and cashflow which ensures you make informed decisions.

All organisations have to perform a number of tasks to make their company financially successful, ERP Accounting software is an essential investment for any business large or small

SapphireOne ERP CRM DMS Accounting software is designed to help companies introduce accounting accuracy to achieve peak financial performance. SapphireOne ERP CRM DMS is built to comply with international accounting standards and principles, providing comprehensive reporting functionality to assist in reviewing company performance. SapphireOne ERP CRM DMS is a unique accounting software.

Managing Cash Flow

One of the biggest challenges for any business is to manage cash flow efficiently, organisations and business owners need to keep records of all the cash coming in and going out of the business. SapphireOne ERP CRM Accounting software enables business owners to manage their business cash flow management of expenditure and keeps track of the financial status of the company easily.

Invoice Tracking with DMS

Invoice tracking is very important for any organisation’s success. SapphireOne’s in-built document management system (DMS) allows you to attach all supporting documentation by simply clicking on SapphireOne’s paperclip in any related transaction and ensures easy invoice tracking. 

Time Saving and Accuracy

SapphireOne ERP Accounting software quickly performs different tasks such as invoicing, sending payment reminders, paying vendors, reconciling bank accounts and generating reports. SapphireOne ERP accounting software provides fast and accurate information. SapphireOne provides a clear and accurate view of the financial standing of your organisation to assist you in managing your business and making informed decisions.

Accounts Receivable

The Accounts Receivable module in SapphireOne’s accounting software is for the entry of all transactions that are involved with Income for the organisation. This may be through Cash Sales or Client Invoices etc. Client accounts are managed efficiently with customer tracking, invoice management, activity analysis, receipt and cash receipt processing.

Accounts Payable

The Accounts Payable module in SapphireOne’s accounting software handles all transactions that are involved with the payment of vendor invoices for the company, this includes the tracking of cash, credit card and eft and other types of payments.

Financial Reporting

SapphireOne ERP CRM DMS accounting software has comprehensive reporting functionality which allows you to analyse all aspects of your financial accounts. Designed with flexibility in mind, SapphireOne reports can be designed to meet your requirements and can be sorted by multiple criteria with numerous levels of details to choose from. Strong reporting tools are essential to your organisation and are fully integrated within the SapphireOne ERP CRM DMS Accounting Software application suite.

For a sneak peek at the full capabilities ERPCRMAccounting SoftwareHuman ResourcesPayrollAssets and Document Management,  check out SapphireOne and request a live demo, it is everything you’ll ever need to make your company management a success. Know more about us.

 

Business Accounting Tips for successful Small Business to Mid-size Start-ups

Business Accounting Tips for successful Small Business to Mid-size businesses

With the availability of resources and technology, entrepreneurs today are finding it easy to realize their ‘start-up’ dreams. Governments and funding companies also welcome the entrepreneurs who have a unique idea and a definite plan backing that idea. Every city wants to become a ‘start-up’ hub these days, it is the ‘Golden Age’ of company.

Business Accounting tips is an important component that contributes to the success of an association, many of which failed because they didn’t manage their accounts properly. With the easy availability of resources, corporation tend to ignore the accounts in the initial stages, this could become a burden to manage the company’s financial health in the later stages. For your business to succeed from small scale to mid-size businee, you need to keep your financial records organized and updated. Following these accounting tips will help you in successfully managing your Small Business or Mid-size Startup.

Business Accounting Tips

  1. Accrual Business Accounting or Cash Accounting
    Using Accrual accounting you can track your transactions real-time and can estimate the present financial health of the company. Using Cash accounting, ATO reporting will be updated only after sending or receiving the payments, inventory etc. Use the help of a financial professional on which method to be adopted and which system better supports your business goals.
  2. Paper or Digital
    Digital accounting has taken over the age-old account books and records. Companies are encouraged to go digital thereby saving paper and the environment. Follow the reviews of the available vendors before buying the software if you are going digital.
  3. Documentation
    Whether you choose paper or digital transactions, you need to maintain your documents in good order, this can be done by using a reliable Document Management System. It helps to manage all your digital documents which you can retrieve whenever required. Documents of financial performance, profit and loss statements, budgeting etc. are of critical importance to the success of the organisation.
  4. Inventory Management
    Manage your inventory using location and bay management, record daily production, adjust stock levels. Invoicing is an easy affair now using SapphireOne accounting software.
  5. Cut Unnecessary Expenses
    Reduce unnecessary expenses related to training, paper, maintenance and unnecessary audits using an effective and user-friendly SapphireOne accounting software.
  6. Integration
    Integration of business accounting tips with CRM software will help in the smooth flow of business.

For a sneak peek at the full capabilities ERPCRMAccounting SoftwareHuman ResourcesPayrollAssets and Document Management,  check out SapphireOne and request a live demo, it is everything you’ll ever need to make your company management a success.