Incorrect account type created for a Sales account when posting data from Retail POS to Reckon Accounts

Legacy KB ID: 4695

Question

I have posted by Retail POS end of day file to Reckon Accounts, but my Sales Account is showing as a Bank Account not as an Income Account.  Why?

 

Answer

When an account shows up as a Bank Account after data has been imported into a Reckon Accounts file, it means that that account did not exist in Reckon Accounts at the time of the import.  The import file did not contain setup information for the account so by default Reckon Accounts created the account as a Bank type. 

If you have previously imported your end of day data without problems, then it is likely that the target account was renamed since the last posting of Retail POS data.  The change was not notified to Retail POS through a Transfer of Data from Reckon Accounts to Retail POS.

 

Workaround

If you backed up your Reckon company file immediately before posting the End of Day file:

1.    Restore the backup of your Reckon Company File;

2.    Open your company file and in the Chart of Accounts, examine the relevant accounts, identify the changed account and rename it to its original name.  To rename an account:

a.    Right click the account in Chart of Accounts and select Edit Account;

b.    Change the name in the Account Name field and click OK.

3.    Retrieve the End of Day File from the Recycle Bin:

a.    Right-Click the Recycle Bin icon on the desktop and select Open;

b.    Find your End of Day file – it has the format:

QBPst – computername – ddmmyy hhmmss – 001.pos;

c.    Right click it and select Restore.  Your file will be restored to its original location. 

4.    Post the End of Day file to Reckon Accounts;

5.    If your account is to have a new name, rename that account.  In Retail POS, transfer data from Reckon Accounts.

 

If you do not have a Reckon Accounts backup immediately before Retail POS data was posted:

1.   In Reckon company file create a backup of the company file.  Do not override existing backups;

2.   In the Chart of Accounts, right click the newly created account and Select QuickReport;

Set the Date Range to the Date Range of the end of Day file;

3.   Click on the first entry to open the document.  Print it and then click Ctrl+D to delete it;

4.   Repeat the Step 3 for each entry on the report.  The balance on this account will reduce to 0.00; 

5.   In the Chart of Accounts, highlight the account and click on Edit > Delete Account;

6.   Re-enter the printed documents to the appropriate account. 

7.   In Retail POS, transfer data from Reckon Accounts.   

 

How did we do?

Error – 13 type mismatch when clicking the price button in the POS Admin Product List screen

Error 13 when posting End of Day to QuickBooks – missing accounts

Related Articles

Incorrect account type created for a Sales account when posting data from Retail POS to QuickBooks
RPC Server unavailable when posting from POS to Reckon Accounts
Reckon Accounts Desktop: Deposit To different account in Sales Receipts
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)