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

Legacy KB ID: 4694

Question

I have posted by Retail POS end of day file to Quickbooks, 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 QuickBooks file, it means that that account did not exist in QuickBooks at the time of the import.  The import file did not contain setup information for the account so by default QuickBooks 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 QuickBooks to Retail POS.

 

Workaround

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

1.    Restore the backup of your QuickBooks 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 QuickBooks;

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

 

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

1.   In QuickBooks 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 QuickBooks.   

 

How did we do?

Setting up an Item Prompt on a POS Terminal

Accounts Business hangs when creating a POS database file

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)