Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 914262 - Last Review: July 28, 2011 - Revision: 3.0
How accounts are mapped when you use the POS Connector with Microsoft Retail Management System Store Operations and with Microsoft Point of Sale
This article describes how the POS Connector maps Microsoft Point of Sale (POS) or Microsoft Retail Management System Store Operations posting accounts for Microsoft Office Small Business Accounting.
The following table shows how the POS Connector maps Microsoft POS posting accounts or Store Operations posting accounts by default to the general ledger accounts in Small Business Accounting. The following mappings occur by default only if you configure your company in Small Business Accounting using the setup wizard by selecting
Retail and
Products and Services as the company type.
Microsoft does not represent that these mappings will be appropriate for your company. It is the responsibility of every user to contact their accountant for more information about mapping requirements and about how to change the default mapping when required.
Collapse this tableExpand this table
| POS/RMS Account | Small Business Accounting GL Account | Number | GL Account Type |
| COGS
| Purchases
| 5015
| Cost of Goods Sold
|
| Inventory
| Inventory POS
| 1251
| Other Current Assets
|
| Sales
| Sales
| 4020
| Income
|
| Tender Received
| Undeposited Funds
| 1005
| Cash
|
| Tender Paid Out
| Miscellaneous Expense
| 8190
| Other Expense
|
| Tender Over/Short
| Cash Over/Short
| 4030
| Income
|
| Tender Rounding
| Cash Over/Short
| 4030
| Income
|
| Debit Surcharge
| Miscellaneous Income
| 8050
| Other Income
|
| Cash Back Surcharge
| Miscellaneous Income
| 8050
| Other Income
|
| Shipping Costs
| Purchases
| 5015
| Cost of Goods Sold
|
| Sales Tax Paid
| Purchases
| 5015
| Cost of Goods Sold
|
| Shipping Income
| Sales
| 4020
| Income
|
| Layaway
| Layaways
| 2340
| Current Liability
|
| Customer Accounts
| Customer Accounts POS
| 1260
| Other Current Liabilities
|
| Customer Deposits
| Customer Deposits
| 2320
| Current Liability
|
| Commission Liability Account
| Commissions
| 2260
| Current Liability
|
| Commission Expense
| P/R Commissions
| 7115
| Expense
|
For the Tax Collected account in POS or it Retail Management System, you must create a tax account. You must assign your own account number. You must assign the GL account type for the tax account by using the Small Business Accounting setup.
For more information about the POS Connector tool for Microsoft Retail Management System Store Operations, visit the following Microsoft Web site:
For more information about the POS Connector tool for Microsoft Point of Sale, visit the following Microsoft Web site:
APPLIES TO
- Microsoft Business Solutions Point of Sale 1.0
| kbmbsmigrate kbinfo KB914262 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate