Inter Company transactions Made easy

Inter Company transactions Made easy

ASP inherited a client a year ago and have been making gradual changes to their system, with a vision of increasing productivity and efficiencies.

One of the larger and most beneficial procedure we introduced was to integrate their payroll and offsite daily store sales data, removing the requirement to rekey data.  With over 42 stores, this had substantial cost savings to the client.

However, with a head office management and maintaining 43 different Sage data sets, the task of “Recharging” costs from head office to the individual stores (eg, appropriating legal or accounting fees), was a huge task requiring the data entry operators to enter a receivable in the head office data, and manually enter each individual company to offset the Payables side back to head office.

Solution:

ASP wrote a front end Excel spreadsheet, which allowed the data operator to enter the charge to HO, and the apportionment to the stores manually. This was saved and our code writes this to a table in the Accpac database.

Then once a week, the operator enters head office Accpac, runs a routine which applies the receivable and payable invoices in the respective data set automatically..

They estimate they are saving 3 person days per month

If you have a similar need, please call 1300 650 222

About the Author

John Waters (Director of Accounting Software Professionals) attained his IT and Accounting skills during the years when accounting systems were in their infancy. Spotting a niche in his chosen proefession as a Chartered Accountant, he has created a brand and breed of CA that bridges the gap between management needs and IT deliverables.