Importing Transactions into Reckon Accounts or QuickBooks.
Many people want to import into Reckon Accounts transactions that are created
For example transactions created on a web page,
or time sheets for hours worked by employees created on a spread sheet.
To manually recreate transactions in your accounting package takes time and is susceptible to input errors.
There are packages that will do this in a simplistic form (customer goes to
customer field, Item goes to item field.)
but some users want a more complex, this is where I come in. In principle the data is manipulated into a format that the
user requires, based on rules that we set. Below are some jobs that have been done that will give you an idea as to
what can be done for you.
If you think that I can help call me on 042 999 2468 or
The most complex job is the log keeping system for Gliding Clubs on detailed on the Log Keeping Page.
A client sells printed and embroidered clothing on the internet.
The data from the web page is processed and the following transactions are created in Reckon / QuickBooks.
An invoice is created to the customer if they have an account or
A sales receipt if payment was made.
A purchase order is created to the garment preferred supplier , But only for those items that are non stock items in the accounts.
Stock items will not be purchased as they come off the shelf in the warehouse.
A contractor who works for a training organisation fills out a spread sheet detailing the work that he has done for various clients.
The system allows the contractor to fill out forms to create new customers or jobs, that will be imported into Accounts.
The simple spread sheet has two columns that detail the amount that the client will be charged, and an additional column that shows expenses to be incurred.
At the end of the month the spread sheet is sent to head office, and an end of period file is created.
When imported into Accounts a number of transactions are created.
An invoice to each Customer / Job for the work done including the expenses incurred.
A single Recipient Created Invoice, that will be turned into a Bill, that will reimburse the contractor a fixed percentage of the fees charged,
and the expenses reimbursed in full.
A company hires out labour, that is then charged to their customer.
The works manager fills out a spread sheet detailing the time each employee has worked each day of the week.
This sheet is signed off by the companies client.
At the end of the week the cleared spread sheet is sent to head office where an end of week process is run and an import file is bought into Reckon Accounts.
This end of day file creates a time sheet for each employee that has calculated overtime, in addition to some extras where required.
The time sheet also allocates the costs to the customers file so that they can be invoiced for the time.
Class tracking is also done within the process.
|James Cooper's lives in Perth Western Australia his web page details QuickBooks or Reckon a business accounting system, Glider Log Keeping, SmartLogs Details the exciting sport of Gliding at Cunderdin, and much more.|