Our particular skills are in designing computer routines for our client's particular requirements. These routines are designed to operate within the standard facilities of the Sage package software.
The benefit to the client is that they use the standard program, fully supported by the Sage Group plc and Computerised Accounting
Here are some examples of solutions we have created for specific clients:
Temp Employment - linking Temp bookings to Client Billing and SAGE Payroll.
A one-step operation links the Sage amount invoiced to clients to the rate paid to the temp and transfers this directly to the Sage Payroll program on a weekly or monthly basis. These link directly into the core Sage accounting modules and the whole system is fully integrated.
Multiple-Location Stock with Component & CMT Production Control.
This system allows product stock in multiple locations, with an on-screen sort-and-search facility per product code or location. Invoicing and/or stock valuations can be done per location or product code type. The sales order-processing section provides sales order analysis per client/per product giving vital information for purchase order processing. Manufacturing and component purchase orders are controlled separately by the system, giving up-to-date progress tracking reports. The system reports on component and finished product re-order levels, re-order quantities and stock shortfalls (insufficient purchases to cover sales orders).
Customer Database and Contact Management.
The standard sort-and-search facility in the Customers' Sage database can provide selection criteria for any kind of analysis required by contact managers. Pre-formatted letters can then be printed with the Sage Customer Ledger address details, quickly and simply achieving a perfect mail merge.
Dual Currency Invoicing and Transaction Conversion.
Invoices can be printed in another currency - say US$ - but posted to the accounting system in the base currency. The base currency trial balance can be converted into another currency at a changeable exchange rate and then be available for consolidation.
Multiple Cost Centre Budget and Profit & Loss Control.
The standard Sage Line 50 program does not allow departmental budget analysis. We have been aware of this problem and have solved it already. Cost centre/Departmental Trial Balances can be printed and actual against budget reports can be produced for any number of cost centers. We have a system to automatically create new cost centre coding structures.
Restaurant Takings Accounting.
The system controls the daily sales calculated net of Vat with any kind of analysis of food, wines and beverages. The cash, cheques and PDQ's are balanced to these figures automatically updating the bank and cash-on-hand accounts. The system will show any overages or shortages on the day's takings. Suppliers' invoices are entered into the system using similar analysis codes so that gross profit percentages can be calculated for control purposes. The system can be set up for restaurant chains allowing data to be captured on a wide-area network basis but centrally controlled.
Property, Utility or Agency Companies - Invoices/ Payments re-creation.
By accessing data set up in the customers and suppliers ledgers invoices, receipts and payment vouches can be automatically re-created for specified periods. The resulting transactions can be previewed and then imported into the appropriate ledgers.
Stock Run-out Reporting System
Stock Run-out Reporting System Vernon Pools is one of the major Football Pools companies. A Stationery Stock Re-order system is vital as a delay of even 1 or 2 days could cost millions in lost coupon revenue. They had a semi-manual control set up in Excel but it was complicated and needed a lot of manual input and maintenance. We produced a solution quite quickly using Sage Line 50 Financial Controller. We developed a specialised report within the products module. From this all that is necessary is a manual comparison of the re-order level calculated by the Sage system and then adjust the stock records where appropriate. The Sage system will automatically highlight where the actual Quantity in Stock is below the new Re-Order level.
Artists' Invoicing Control
Our client manages well-known TV & theatrical personalities and invoices broadcasting studios and theatres on their behalf (plus VAT if the artist is registered). They previously used a complicated manual "red book" and Excel spreadsheet. However it was only the person who wrote it up who could understand what was outstanding from the theatres and what was due to be paid to the artists (less the appropriate commission). We solved the problem using the Sage Line 50 Accountant Plus program. A Sage report now lists outstanding sales invoices, which are sorted and sub-totalled by artist. In the invoicing module the actual invoices are extracted per artist and flagged whether paid (to the artist) or not. A statement is then prepared in Sage, listing the invoices not paid to the artist but now due for payment. A commission credit is passed and a final "Artists" statement can then be printed and sent to artist with the appropriate money transfer. The beauty of the system is that all this information is held within Sage and these reports can be produced in a matter of minutes by any of the Sage operators. Many hours of a manual system involving complicated crosschecking have been saved and errors eliminated.
Computerised Accounting, 84 Brook street, Mayfair, London, W1K 5EH
T: 020 7434 3571 email: sales@computerisedaccounting.com