SUMMARY



SUMMARY

Beginning with version 1.2 of Microsoft Business Solutions Retail Management System, Store Operations, customers can directly integrate with QuickBooks 2003, QuickBooks 2004, or QuickBooks 2005. The supported versions are QuickBooks Pro, QuickBooks Premier, QuickBooks Premier: Accountant Edition, QuickBooks Premier: Contractor Edition, and QuickBooks Enterprise Edition.

After the initial installation, you can export your accounting data directly in the QuickBooks general ledger and also export closed Purchase Orders as QuickBooks bills.

The integration of QuickBooks with Store Operations includes five stages:

|1. |Configure QuickBooks to interact with Store Operations. |

|2. |Configure Store Operations to interact with QuickBooks. |

|3. |Import data from QuickBooks. |

|4. |Assign general ledger accounts in Store Operation Manager. |

|5. |Export accounting and purchase order data directly to QuickBooks. |

Microsoft Business Solutions Retail Management Systems technical support cannot advise you about how to set up your general ledger account assignment tables or where and when to post the data to QuickBooks. Technical support strongly urges you to obtain advice from a qualified professional. This article only contains information to help you integrate Store Operations with QuickBooks.

|[p|Back to the top |

|ic| |

|] | |

INTRODUCTION

This article discusses how to integrate QuickBooks 2003, QuickBooks 2004, or QuickBooks 2005 with Store Operations 1.2.

|[p|Back to the top |

|ic| |

|] | |

MORE INFORMATION

Stage 1: Configure QuickBooks to interact with Store Operations

|1. |Start QuickBooks. |

|2. |Click Accnt on the standard toolbar or click Lists, and then click Chart of Accounts to view the Chart of Accounts. |

| | |

| |Note To view the accounts that you may have to add in Store Operations, start Store Operations Manager, click Journal, and |

| |then click Assign general ledger Accounts. |

|3. |Click Edit, and then click New Account to add any accounts that you may want to track. For example, add accounts if you want|

| |to track sales, commissions, and cost of goods sold (COGS) for each department. |

| | |

| |Note There are also two accounts that you must add in QuickBooks. For more information, see step 5. |

|4. |Add the remaining information in the New Account screen, and then click OK. |

| | |

| |Note QuickBooks does not permit more than one Accounts Payable or Accounts Receivable account type per transaction. |

| |Therefore, you must use Other Current Assets and Other Current Liabilities instead of Accounts Receivable and Accounts |

| |Payable if you are setting up a new account that would ordinarily use these account types. |

|5. |Click Edit, and then click New Account to create a new Sales Tax Payable account. This name must be different from the |

| |default QuickBooks account. For example, name the account Sales Tax Payables. |

| | |

| |Note You cannot use the default Sales Tax account in QuickBooks when you assign any one of the Sales Tax accounts in Store |

| |Operations. You must create a new Sales Tax account in QuickBooks. |

|6. |Click Other Current Liabilities for Account Type. |

|7. |Add the remaining information in the New Account screen, and then click OK. |

|8. |Click Edit, and then click New Account to create a new Accounts Receivable account. This name must be different from the |

| |default QuickBooks account. For example, name the account AR. |

| | |

| |Note You cannot use the default Accounts Receivable account in QuickBooks when you assign either the Store Account: Paid On |

| |or the Store Account: Paid To accounts in Store Operations. You must create a new Accounts Receivable account in QuickBooks |

| |because the standard Accounts Receivable account type in QuickBooks requires more information than Store Operations |

| |provides. |

|9. |Click Other Current Assets for Account Type. |

|10. |Add the remaining information in the New Account screen, and then click OK. |

|11. |Determine the account that you want to use for the Bills account. This account offsets the Account Payable account when a |

| |QuickBooks Bill is created. You or your accountant determine this account. |

| | |

| |Note You cannot use the default Accounts Payable account in QuickBooks when you assign the Bills Account in Store |

| |Operations. Store Operations automatically posts to the Accounts Payable account in QuickBooks when you are posting the |

| |closed Purchase Orders. Therefore, you must select a different account. |

|12. |If you do not want to use any one of the accounts that are listed for the Bills account, you must create one. If an account |

| |already exists, go to the "Part 2: Set up Store Operations to interact with QuickBooks" section. |

|13. |Click Edit, and then click New Account to create a new account. |

|14. |In the Type list, click the account type. |

| | |

| |Note You or your accountant must determine the account type, but it cannot be Accounts Payable. |

|15. |Add the remaining information in the New Account screen, and then click OK. |

| | |

| |Note If you assign vendors or customers to this account, you may cause errors during posting. |

|[p|Back to the top |

|ic| |

|] | |

Stage 2: Set up Store Operations to interact with QuickBooks

In this stage, you select QuickBooks as your accounting software and connect to the QuickBooks company file.

|1. |Start QuickBooks. |

|2. |Sign in to your company as a user with administrator credentials. |

|3. |Start Store Operations Manager. |

|4. |Click File, and then click Configuration. |

|5. |Click the Accounting tab. |

|6. |In the Accounting Information pane, click QuickBooks 2003 in the list. |

| | |

| |Note Click QuickBooks 2003 even if you are using a later version of QuickBooks. |

|7. |To connect with QuickBooks and to retrieve information about the company file, click Retrieve in the Company Information |

| |pane. |

| | |

| |Note If the Internet Security Levels Are Set Too High dialog box appears, you must click Make Changes or Cancel. If you |

| |click Cancel, you must click Yes to confirm your selection. If you click Cancel, you may prevent some QuickBooks features |

| |from working correctly. |

|8. |In the QuickBooks - Application Certificate window, use one of the following methods: |

| |• |

| |Click Yes, Always to grant permanent access from Store Operations to your QuickBooks company file. |

| | |

| |• |

| |Click Yes, This Time to grant access on this occasion only. You will be prompted for authorization on later attempts. |

| | |

|9. |After you connect to QuickBooks and retrieve the company information, click OK two times. |

|10. |For Store Operations to automatically log on to QuickBooks, follow these steps. |

| | |

| |Note Every time that you interact with QuickBooks in Store Operations, the QuickBooks program must be running. You can start|

| |QuickBooks manually and log on to the company file, or your QuickBooks administrator can set up the automatic logon feature.|

| |When you use the automatic logon feature, QuickBooks does not have to be running. |

| |a. |

| |Start QuickBooks. |

| | |

| |b. |

| |Click Edit, and then click Preferences. |

| | |

| |c. |

| |Click Integrated Applications in the left pane. |

| | |

| |d. |

| |Click the Company Preferences tab. |

| | |

| |e. |

| |Click Retail Management System, and then click Properties. |

| | |

| |f. |

| |Select the Allow this application to log on automatically check box. |

| | |

| |g. |

| |Click the user's logon name, and then click OK two times. |

| | |

| |Note The user must have the correct access permissions. |

| | |

|[p|Back to the top |

|ic| |

|] | |

Stage 3: Import data from QuickBooks

The Import Data from QuickBooks Store Operations function imports the Chart of Accounts from QuickBooks. You can also import Payment Terms, Customers, Suppliers (Vendors), and Items if these terms are defined in QuickBooks.

Note The integration does not allow you to import Payment Terms, Customers, Suppliers (Vendors), and Items from Store Operations to QuickBooks.

|1. |Start Store Operations Manager. |

|2. |Click Utilities, and then click Import QuickBooks. |

| | |

| |Note If Import QuickBooks is not listed, follow the instructions in the "Part 2: Set up Store Operations to interact with |

| |QuickBooks" section to select QuickBooks 2003 as your accounting software. |

|3. |Select the data that you want to import. You can select Accounts, Payment Terms, Suppliers (vendors), Customers, and Items if|

| |these terms are defined in QuickBooks. |

| | |

| |Note We recommend that you import information in the default order that appears in the Import QuickBooks window. If you |

| |change this order by re-sorting the columns, data may not be imported with the correct relationships. For additional |

| |information about importing, search for the "Import QuickBooks Option" topic in Store Operations Manager Help. |

|4. |Click Import. The status appears as the data is imported. |

| | |

| |Note If a record already exists in Store Operations, you are prompted to select an import conflict resolution. You can update|

| |Store Operations with the QuickBooks record, create a new record, or not import the record. |

| | |

| |Note Because the Chart of Accounts and Payment Terms is maintained in QuickBooks, Store Operations automatically replaces the|

| |Account and Term records with the QuickBooks imported records. You will not be prompted to select an import conflict |

| |resolution. If prompted, select a resolution. To do this, use one of the following methods: |

| |a. |

| |To apply the resolution only to the current record, click Apply. |

| | |

| |b. |

| |To apply the resolution to all records of the same type, such as all Customer records, click Apply to All. |

| | |

| |c. |

| |To stop the import, click Abort. |

| | |

| |Note If you abort the import, you can verify what records were imported before the interruption. To view the list of records,|

| |click Items, Customers, or Suppliers on the Database menu. To use the list to view the imported accounts, click Assign |

| |General Ledger Accounts on the Journal menu. You can view imported terms in the Supplier Properties window. |

| | |

|[p|Back to the top |

|ic| |

|] | |

Stage 4: Assign general ledger accounts in Store Operations Manager

You must set up the account assignment table in Store Operations Manager. Microsoft strongly recommends that an accountant set up this table. QuickBooks does not accept a general journal import file if the debits and credits do not balance.

Every time that you add a new tender or tax type, you must update the general ledger account assignments to incorporate these additions. Use the following table to guide you through the types of general ledger accounts that you must enter for each account type listed. The table provides some additional information about these accounts. The table assumes that you are using accounts for Tender Received, Tender Opening, and Tender Closing.

Table: QuickBooks general ledger account setup in Store Operations

|Description |Type of debit |Type of credit |Additional Details |

| |account |account | |

|Inventory: Cost of |Cost of Goods Sold|Inventory |The total cost of items sold. Enter account numbers in these accounts|

|Goods Sold | | |if you want to track this value as a total for all departments. If |

| | | |you want to track this value per department, leave these accounts |

| | | |blank and enter your account numbers in the Dept xxxx: Cost Account. |

|Commission |Selling Expense |Other Current |The commission payable to sales reps. Set up this account if you want|

| | |Liabilities |to track this value for every department. If you want to track this |

| | | |value per department, leave these accounts blank and enter your |

| | | |account numbers in the Dept xxxx: Commission Account. |

|Customer Deposit: | |Other Current |The total deposits that are made from work orders on customer |

|Made | |Liabilities |accounts. |

|Customer Deposit: |Other Current | |The total deposits that are redeemed when work orders are completed. |

|Redeemed |Liabilities | | |

|Layaway: Closed |Other Current | |The layaway amount that is closed when the customer received the |

| |Liabilities | |goods. Store Operations automatically credits the Sales and Tax |

| | | |accounts to balance the posting. |

|Layaway: Paid | |Other Current |The amount paid by customers on new or existing layaway items. Store |

| | |Liabilities |Operations automatically debits the Payment Received accounts to |

| | | |balance the posting. |

|Sales: Total | |Sales |The total sales amount not including tax. If you post this account, |

| | | |you must not post the Sales: Total + Tax account to avoid redundant |

| | | |posting. Set up this account if you want to track this value for all |

| | | |departments and track taxes separately. If you want to track this |

| | | |value per department, leave these Accounts blank and enter your |

| | | |account numbers in the Dept xxxx: Sales account. |

|Sales: Total + Tax | |Sales |The total sales amount plus tax. If you post this account, do not |

| | | |post the Sales: Total or any Tax Collected accounts to avoid |

| | | |redundant posting. Only use this account if you do not track sales by|

| | | |department or sales taxes separately. |

|Shipping Charge: | |Other Income |The amount that is collected for shipping charges. Expense it out |

|Total | | |through the general ledger program. |

|Store Account: Paid |Accounts | |Charges made to Customer Accounts. The offset is to Sales and Tax |

|On |Receivable | |Collected. |

|Store Account: Paid | |Accounts |Payments from customers to reduce their customer balance. The offset |

|To | |Receivable |is to Tender Received. |

|Surcharges: Cash Back| |Other Income |The amount collected for fees that are charged to customers when they|

| | | |receive cash back on their debit purchases. Expense out any fees that|

| | | |are charged to you through the general ledger program. |

|Surcharges: Debit | |Other Income |The amount collected for fees that are charged to customers when they|

| | | |use their debit card for purchases. Expense out any fees that are |

| | | |charged to you through the general ledger program. |

|Tax Collected: Total | |Taxes Payable |The total amount that is collected for sales taxes for all |

| | | |departments. You can post Tax Collected for the individual tax types |

| | | |or for the total tax that is collected. If you post Tax Collected: |

| | | |Total Account, do not post the individual Tax Collected: xxxx |

| | | |accounts to avoid redundant posting. A Tax Collected: xxxx entry is |

| | | |created for each type of tax in Store Operations. Therefore, every |

| | | |time that you add a new tax type, you must update this account to |

| | | |make sure that the posting is correct. |

|Cash Dropped |Cash |Cash |The cash amount that is taken out of the cash drawers for deposit |

| | | |during the cashiers' shifts. |

|Cash Paid Out |Expenses |Cash |The cash amount that is paid out from the cash drawers (for minor |

| | | |miscellaneous expenses). |

|Tender Rounding Error|Cash | |This is the rounding error that may occur when you accept multiple |

| | | |currencies. For example U.S. and Canadian dollars. This error may |

| | | |also occur if pennies are not included in transactions. |

|Tender Closing |Cash or Other |Cash or Other |The total amount that is available when you close the cash drawers |

|Amounts: xxxx |Assets |Assets |for a particular tender type. A Tender Closing Amounts entry is |

| | | |created for each type of tender in Store Operations. Therefore, every|

| | | |time that you add a new tender type, you must update this account to |

| | | |make sure that the posting is correct. For more information, see the |

| | | |notes that appear after this table. |

|Tender Opening |Cash or Other |Cash or Other |The total amount that is available when you open the cash drawers for|

|Amounts: xxxx |Assets |Assets |a particular tender type. A Tender Opening Amounts entry is created |

| | | |for each type of tender in Store Operations. Therefore, every time |

| | | |that you add a new tender type, you must update this account to make |

| | | |sure that the posting is correct. For more information, see the notes|

| | | |that appear after this table. |

|Tender Over/Short: | |Cash or Other |The amount that the tender type is over or short at the end of the |

|xxxx | |Assets |batch. It reflects the errors that the cashiers made during tender |

| | | |transactions. A Tender Over/Short entry is created for each type of |

| | | |tender in Store Operations. Therefore, every time that you add a new |

| | | |tender type, you must update this account to make sure that the |

| | | |posting is correct. If you are using this account, leave the Tender |

| | | |Over or Tender Short accounts blank to avoid redundant posting. |

|Tender Over: xxxx | |Cash or Other |The amount that the tender type is over at the end of the batch. It |

| | |Assets |reflects the errors that the cashiers made during tender |

| | | |transactions. A Tender Over entry is created for each type of tender |

| | | |in Store Operations. Therefore, every time that you add a new tender |

| | | |type, you must update this account to make sure that the posting is |

| | | |correct. If you are using this account, leave the Tender Over or |

| | | |Tender Short accounts blank to avoid redundant posting. |

|Tender Received: xxxx|Cash | |The total amount that is received for a particular tender type. This |

| | | |value is calculated by taking the Closing Amount - Opening Amount - |

| | | |Tender Dropped - Tender Paid. A Tender Received entry is created for |

| | | |each type of tender in Store Operations. Therefore, every time that |

| | | |you add a new tender type, you must update this account to make sure |

| | | |that the posting is correct. For more information, see the notes that|

| | | |appear after this table. |

|Tender Short: xxxx | |Cash or Other |The amount that the tender type is short at the end of the batch. It |

| | |Assets |reflects the errors that the cashiers made during tender |

| | | |transactions. A Tender Short entry is created for each type of tender|

| | | |in Store Operations. Therefore, every time that you add a new tender |

| | | |type, you must update this account to make sure that the posting is |

| | | |correct. If you are using this Account, leave the Tender Over or |

| | | |Tender Short Accounts blank to avoid redundant posting. |

|Tax Collected: xxxx | |Taxes Payable |The total amount that is collected for sales taxes for each |

| | | |department. You can post Tax Collected for the individual tax types |

| | | |or for the total tax collected. Enter account numbers in these |

| | | |accounts if you want to track value this separately for each sales |

| | | |tax. If you want to track taxes as a total, leave these accounts |

| | | |blank and enter your account numbers in the Tax Collected: Total. A |

| | | |Tax Collected: xxxx entry is created for each type of tax in Store |

| | | |Operations. Therefore, every time that you add a new sales tax, you |

| | | |must update this account to make sure that the posting is correct. |

|Dept. xxxx: Cost |Cost of Goods Sold|Inventory |The cost of the items that are sold per department. Enter account |

| | | |numbers in these accounts if you want to track this value separately |

| | | |for all departments. If you want to track this value as a total, |

| | | |leave these accounts blank and enter your account numbers in the |

| | | |Inventory: Cost of Goods Sold. |

|Dept. xxxx: |Selling Expense |Other Current |The commission payable to sales reps by department. Set up this |

|Commission | |Liabilities |account if you want to track this value separately for every |

| | | |department. If you want to track this value as a total, leave these |

| | | |accounts blank and enter your account numbers in the Commission |

| | | |Account. |

|Dept. xxxx: Sales | |Sales |The sales amount not including taxes for the department. If you post |

| | | |this account, do not post Sales: Total + Tax or Sales: Total Account |

| | | |to avoid redundant posting. Set up this account if you want to track |

| | | |sales and taxes for each department separately. If you want to track |

| | | |this value as a total, leave these accounts blank and enter your |

| | | |account numbers in the Sales: Total + Tax or Sales: Total. |

|Department Tax | |Cash |The rounding error that may occur when you calculate the tax per |

|Rounding | | |department in a VAT system. Only this option only if you use VAT. |

Note For the tender amounts to post correctly to your accounting system, type opening and closing amounts in the point of sale for each batch.

Note If you are using Tender Received Amount but not Tender Opening Amount or Tender Closing Amount, you must take the following actions:

|•|Set credit and debit accounts for Tender Dropped and for Tender Paid Out. |

|•|Leave each Tender Opening and Tender Closing amount blank. |

|•|Set the debit amount for Tender Received. |

Note If you are using the Tender Opening and Tender Closing Amounts, but not the Tender Received Account, you must take the following actions:

|•|Set debit accounts for both Tender Dropped and Tender Paid Out and leave their credit accounts blank. |

|•|Leave Tender Received blank. |

To assign general ledger Accounts, follow these steps:

|1. |Start Store Operations Manager. |

|2. |Click Journal, and then click Assign general ledger Accounts. |

|3. |Click the Debit Account # box or the Credit Account # box of the general ledger account that you want to assign. |

|4. |Click the QuickBooks account from the list. |

|5. |Repeat steps 3 and 4 until all the required accounts are assigned. |

| | |

| |Note Not all general ledger accounts have an account that is assigned in the Debit Account # box or the Credit Account # box.|

|6. |Click the QuickBooks account that you are using for the Bills Account from the list if you want to post your closed purchase |

| |orders to QuickBooks as bills. |

|7. |Click OK to save your changes, and then close the Assign general ledger Accounts window. |

|[p| |

|ic| |

|] | |

Stage 5: Export accounting and Purchase Order data directly to QuickBooks

To export your accounting data directly in the QuickBooks general ledger and to export closed Purchase Orders as QuickBooks Bills, follow these steps:

|1. |Start Store Operations Manager. |

|2. |Click Journal, and then click Post Closed Batches. |

| | |

| |Note Only closed batches are available to be posted. |

|3. |Click the batches that you want to post. Or, click Dates to open the Select Batch Range window to type a start date and an |

| |end date. When you click OK, all the batches that are closed and that are in this date range are selected, even if they have |

| |been previously posted. |

| | |

| |Note If you repost a batch that has already been posted, you may have duplicate general ledger and Bill entries in |

| |QuickBooks. Make sure that you delete duplicate records from QuickBooks. |

|4. |If you have set up a Bills Account in QuickBooks, select the Include Purchase Orders check box to import closed purchase |

| |orders that are included in the selected batches. |

| | |

| |Note Closed Purchase Orders are included in the closed batches. You can import Closed Purchase Orders into QuickBooks as |

| |bills when the batch is posted. Before you import Purchase Orders into QuickBooks, you must first select a Bills account in |

| |the account assignment table. The Bills account that you select will offset the Account Payables account when the bill is |

| |created in QuickBooks. |

| | |

| |The Store Operations Purchase Order exports the following information to the QuickBooks bill: |

| |Store Operations PO Field |

| |Quick Books Bill Field |

| | |

| |Purchase Order Number |

| |Reference Number |

| | |

| |Supplier Name |

| |Vendor |

| | |

| |Purchase Order Creation Date |

| |Transaction Date |

| | |

| |Total of the Purchase Order |

| |Amount Due |

| | |

| |Terms |

| |Payment Terms |

| | |

| | |

| |One expense line for posting to the Account specified in the Assign Accounts Bill Posting Account |

| | |

|5. |Click Post to export the account data and the closed Purchase Orders. |

| | |

| |Note If you receive an error message when you post the closed batch, you must view the QBPost.log file that the error message|

| |indicates. Compare the QBPost.log file to the error message articles list in the "References" section. By default, the log |

| |file is in the C:\Program Files\Microsoft Retail Management System\Store Operations folder. |

|6. |Click OK to close the Post Closed Batches window that tells you how many batches were posted. |

|7. |The information that was posted is now available in QuickBooks. |

| | |

| |To create a General Journal report in QuickBooks, follow these steps: |

| |a. |

| |Click Reports, click Custom Transactions Detail Report, and then click the Filters tab. |

| | |

| |b. |

| |Click Transaction Type in the Filter list. |

| | |

| |c. |

| |Click Journal in the Transaction Type list. |

| | |

| |d. |

| |Click to select a date range, and then click OK. |

| | |

| |To view the new QuickBooks Bills, click Bill on the standard toolbar or click Vendors, and then click Pay Bills. |

| | |

| |Note The bills that you post may not be the last bills that are listed in QuickBooks. |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download