When I went to upload the data from Terminal to Quick Books through Point Of Sale Lite 2014 Administrator a Warning Box came up:
"Reckon accounts has detected that one of your items does not have an account associated with it. Go to the Item list to make sure all items are associated with accounts"
I checked and all seemed fine, then I noticed ALL cash sales were nowhere to be found. All items charge to their Customer Account were present in Quickbooks. Do I need to setup something for Cash Sales?! Any help would be appreciated :)
By the sounds of it there has been some issue with your cash payment item in your items list like you may have accidnetly changed which account its going to it and performed a transfer midway through the day, with thst being the case you will need to do a quick google search for "Error on line XX when importing IIF Files" and follow the instructions on how to edit iif files.
1) Perform an end of day "Z" read on all your POS Terminals.
2) open your item list in Reckon Account(formally quickbooks) and edit your CASH payment item in the items list and make sure you have that associated to a bank account eg "Cash Register funds"
3) Perform a Transfer in POS Admin.
4) POS end of day files are the files next to your POS database that have a ".pos" extension and the terminal name at the beginning eg "QBPst - Terminal - 150204 125443 - 001.pos". These are actually IIF files that have had the file extension changed for use with POS.
Using the doc that you find by google, open each end of day file and have in column " i " for the word "CASH", once you've found it look on the same line in column "D" and make sure that the account name that you've specified in step 2 is listed. if it isn't then manually type in the name of the account making sure to type it verbatim, no extra spaces or incorrect capitalisation. do this on all lines and once complete click the save icon at the top of excel or press Ctrl+S then exit excel, when it askes if you want to save again click no or excel will try and change the format to something else.
5) repeat step 4 for all end of day files.
6) now we need to import the transactions into reckon accounts, to do this first create a backup of reckon accounts, we are importing data that may fail after all so better to be safe then sorry.
after that click on File>Utilities>Import>IIF Files. browse to the location of your end of day files, you may need to select the options to show all file types to see these unless you manually changed the file extensions from .pos to .iif. Import one and check your audit trail report(Under accountant sub report menu). assuming it was successful do the next and do on.
if you had an issue importing any of the files you will need to restore your backup and import after making alterations, just remember to import the once you corrected successfully before finishing up
once all the files have been imported successfully you can now delete the end of day files.
once this is all done and dusted I would recommend creating a cash sale in POS for 1 dollar and performing an end of day and posting the file into reckon accounts. and confirming correct operation before finishing up, if successful then Happy days :)
Oh I forgot,
if you need more info on this please call the Reckon Accounts Support team and they can assist you or contact an accredited partner and they can do it for you.
Thanks so much for your reply. This is really frustrating me lol. I dont need to recover any transactions as I am just testing the system before I use it. I noticed under Item List in Reckon Accounts Plus 2014 there was an item called Cash, I associated the Cash with the Cash Register Funds and then did everything you say. End of day, transfer to Reckon Accounts and transfer back etc and the same error comes up. I have attached screen shots and hoping these will help. THanks in advance :)
Thanks for that screen shot that makes it soo much easier, the issue is that the item you have in there is a service item, it should be a payment item. I would suggest renaming the item you currently have in there as "CASH" to be "CASH1" then wither creating a new payment item called cash or importing the file called "QBSTAND.pos" from the pos admin install directory as that has all the base items required for pos to work successfully.
then transfer again and try the test sales again.
on a side note, where it says "error on line X" the number that it is stating will be the last line of a transaction. what its actually saying is there is an issue somewhere in that transaction not necessarily that line.
in column A the sequence will be something like this
LINE3 LINE1 ENDTRNS
which is basically a guide for Reckon Accounts to read the transaction so basically
LINE1 BEGINING OF NEW TRANACTION
LINE3 END OF TRANSACTION
So using the example above error on line 3 would mean there is something wrong with either lines 1 or lines 2.
Thankyou Linda for your advice too, I have copied and pasted it down incase I need it for a future problem. Have tested it several times and it works a treat! Thankyou both very much!!!! :)