How accounts are mapped when you use the POS Connector with Microsoft Retail Management System Store Operations and with Microsoft Point of Sale (914262)



The information in this article applies to:

  • Microsoft Retail Management System Store Operations 1.3
  • Microsoft Point of Sale 1.0
  • Microsoft Office Small Business Accounting 2006

INTRODUCTION

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.

MORE INFORMATION

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.

POS/RMS AccountSmall Business Accounting GL AccountNumberGL 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

Note 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.

REFERENCES

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:

Modification Type:MinorLast Reviewed:3/8/2006
Keywords:kbinfo kbMBSMigrate KB914262 kbAudEndUser