Simply Accounting Initial Setup Guide

 

Table of Contents

Step 1:  Create Sysadmin User

Step 2:  Create CASHSALES Customer

Step 3:  Create Tender Summary Account

Step 4:  Enable Inventory Levels to Go Below Zero

Step 5:  Setup Simply Accounting Adapter

Step 6:  Set Management to Canada

Step 7:  Import the Inventory

Step 8:  Define Tender Summary Account

Step 9:  Define GL Accounts for Tendering Codes

Step 10:  Test the Integration

 

SIMPLY ACCOUNTING INITIAL SETUP:

 

This guide was written for Platinum Version 9 of AccuPOS Retail Management.  If you are running an earlier version of AccuPOS or not running Platinum, you will notice differences in the look of the Retail Management program.  Also, the Simply Accounting images and setup steps were written with Simply Accounting Enterprise 08.  If you are running a different version of Simply Accounting, there will also be slight differences in the look but the setup is not that different.

 

In order to use AccuPOS Retail Point of Sale and have it update Simply Accounting for inventory and accounting purposes, a Simply Accounting company file must be set up beforehand and the location on the local network, or computer, of the company file must be known in order for AccuPOS to connect and update the company file.  If this is the first time installing Simply Accounting, please consult your Simply Accounting advisor or Sage’s customer support with questions pertaining to accounting issues while setting up the new company.  AccuPOS support staff will only support issues regarding Simply Accounting that affect the integration with AccuPOS Retail Point of Sale.

 

This guide is also under the assumption that the network is setup and all software installed according to the AccuPOS Network Setup Guide.  The adapter, AccuPOS Retail Management, and AccuPOS Point of Sale must be installed on the network or computer.

 

Step 1:  Create Sysadmin User: (top)

 

Before AccuPOS can communicate with Simply Accounting, the sysadmin account must be created/setup inside the Simply Accounting company file.  This is to ensure the connectivity of the AccuLINK adapter to Simply Accounting.  To set this user up:

 

  1. Go to Setup -> Setup Users & Roles… (Figure 1-1).  The Setup Users & Roles window appears.

 

Figure 1-1

 

  1. Select the default sysadmin user and select Modify User.  (Figure 1-2)

 

Figure 1-2

 

  1. Set a user password for this user (in this example, our password is “accupos”) and set the user’s third party rights to read/write access.  (Figure 1-3)

 

Figure 1-3

 

  1. Hit OK when you’re finished.  You may receive a warning about granting third party access to this user.  Select NO to save the changes made.
  2. Select Close to exit the Setup Users & Roles window.

 

It is extremely important to know the sysadmin’s password.  If it is lost or forgotten, not only will you not be able to log into Simply Accounting, AccuPOS also will not be to communicate with it as well.

 

Step 2:  Create CASHSALES Customer: (top)

 

All transactions that are processed at the Point of Sale that have no customer attached to them will post as one summarized Sales Receipt inside of Simply Accounting.  Even if you are planning to track customers on every transaction at the Point of Sale, this customer must be created in Simply Accounting for AccuPOS Retail to integrate properly.  To set up this customer:

 

  1. From the Receivables tab, select Customers (Figure 2-1).  The Customers window appears.

 

Figure 2-1

 

  1. Select Create (Figure 2-2).  The Receivables Ledger window appears.

 

Figure 2-2

 

  1. Enter CASHSALES as the Customer Name.  (Figure 2-3)

 

Figure 2-3

 

  1. Under the Import/Export tab, select the option This customer uses my item numbers on orders.  (Figure 2-4)

 

Figure 2-4

 

  1. Select Save and Close once you’re finished.

 

Step 3:  Create Tender Summary Account: (top)

 

The Tender Summary account enables AccuPOS Retail to split the tendering totals coming from the Point Of Sale at the end of the shift when Simply Accounting is updated with the sales information.  This account must be a BANK ACCOUNT inside Simply Accounting.  If you are running Simply Accounting 07, this Tender Summary account must be defined as the default bank account.  The Tender Summary allows the splitting of the different tendering totals from a particular day’s sales (for example, splitting up all MasterCard transaction totals from Cash transactions totals).  When Sales information is sent into Simply Accounting, all the information goes into the Tender Summary account and from there, it moves into specified GL Accounts.  More information on that is later on in the guide.  To create a Tender Summary account:

 

  1. From the Company tab, select Chart of Accounts and select Add Account (Figure 3-1).  The General Ledger window appears.

 

Figure 3-1

 

  1. Set the Account number to 1001 and the Account name to Tender Summary.  (Figure 3-2)

 

Figure 3-2

 

  1. Under the Class Options tab, set the Account Class to Bank and the Account Type to Chequing.  (Figure 3-3)

 

Figure 3-3

 

  1. Select Save and Close once you’re finished.

 

The Tender Summary also serves as an audit trail.  The balance of the account must always be $0.00.  Every day after Simply Accounting is updated by AccuPOS, make sure to check the balance of Tender Summary.  If is remains at $0.00, the sales information was imported correctly.  If it is either positive or negative, contact your dealer or AccuPOS Technical Support immediately.

 

Step 4:  Enable Inventory Levels to Go Below Zero: (top)

 

AccuPOS Point of Sale, when importing sales into Simply Accounting, will need, at time, to decrease the quantity on hand for an inventory item below zero.  Simply Accounting must be configured to allow item quantities to go below zero.  Once in Single-User mode in Simply Accounting:

 

  1. From the Company tab, select Settings (Figure 4-1).  The settings window appears.

 

Figure 4-1

 

  1. Select Inventory & Services -> Options.  (Figure 4-2)

 

Figure 4-2

 

  1. Select the option Allow inventory levels to go below zero.  (Figure 4-3)

 

Figure 4-3

 

Step 5:  Setup Simply Accounting Adapter: (top)

 

Now that everything is set up inside Simply Accounting for AccuPOS to integrate properly, it is time to set up the AccuLINK adapter.  For information on how to install the adapter, please refer to the AccuPOS Network Setup Guide.  To setup the adapter:

 

  1. Open the Simply Adapter.  There should be a shortcut on the desktop after the adapter was installed.
  2. Select Setup (Figure 5-1).  The AccuLINK Configuration window appears.

 

Figure 5-1

 

  1. Select Path to Import.EXE (Figure 5-2).  A windows explorer window will open and you must set the path to the import.exe file that Simply Accounting creates once installed.  In the example below, it is located at C:\Program Files\Simply Accounting Accountants' Edition 2008\SimplyAccounting_import.exe.

 

Figure 5-2

 

  1. Enter the password for the sysadmin user account.  (Figure 5-3)

 

Figure 5-3

 

  1. Select Canada for the country version.  If you are using Simply Accounting 2008, select that box as well.  (Figure 5-4)

 

Figure 5-4

 

  1. Select Add/Modify Site.  (Figure 5-5)

 

Figure 5-5

 

  1. Select Browse Company Path (Figure 5-6).  A windows explorer window will open and you must set the path to your company file saved on your network or local computer.  (Figure 5-7)

 

Figure 5-6

Figure 5-7

 

  1. Select Save when the path is set.  (Figure 5-8)

 

Figure 5-8

 

  1. Once all settings are configured, select Save to exit the AccuLINK Configuration window.  (Figure 5-9)

 

Figure 5-9

 

Step 6:  Set Management to Canada: (top)

 

AccuPOS Retail Management must be set to read the taxes set up in Canada.  To set up this tax system:

 

1.      Go to Setup -> Company Information (Figure 6-1).  The Company Information window appears.

2.      On the left side use the drop down for Country and change it to Canada.  (Figure 6-2)

 

Figure 6-1

 

Step 7:  Import the Inventory: (top)

 

Now that the adapter has access to QuickBooks, it is time to import all the inventory into AccuPOS Retail Management.  To Import inventory, open up AccuPOS Retail Management:

 

1.      Go to File -> Import Inventory from Accounting.  (Figure 7-1)

 

Figure 7-1

 

2.      The AccuPOS Integrator will make a call to the adapter to tell it to grab the inventory from Simply Accounting.  It will only flash for a second on the screen and then disappear. (Figure 7-2)

 

Figure 7-2

 

3.      The adapter will receive the request and begin getting the items.  (Figure 7-3)

 

Figure 7-3

 

4.      Once the items are exported (Figure 7-4), the AccuPOS Integrator will pop back up and update all the items and then disappear again.  (Figure 7-5)

 

Figure 7-4

Figure 7-5

 

Step 8:  Define Tender Summary Account: (top)

 

The Tender Summary account must be defined inside AccuPOS Retail Management to make sure it integrates correctly:

 

1.      Go to Setup -> Company Information.

2.      Enter “1001” (or whatever account number you assigned to this account in Step 3) in the Tender Summary Account field.  By default, it is set to Undeposited Funds.  (Figure 8-1)

 

Figure 8-1

 

Step 9:  Define GL Accounts for Tendering Codes: (top)

 

As stated in Step 3, AccuPOS sends sales information into accounts specified in the AccuPOS Retail Management.  AccuPOS recommends posting tender types that are alike to the same GL account, so they can be easily identified in Simply Accounting for deposit purposes.  For example, Cash and Checks should post to the Cash to be Deposited account (usually 1020), Visa and Master Card to a Visa-Master Card account (1025 for example), etc. At the end of each day, the Cash and the Checks can be deposited using Simply Accounting Make Deposits function, and a General Journal Entry can be made out of the other tendering GL Accounts to the bank account in one lump sum. Doing so will imitate the way the deposits are made in real life, and will make the reconciliation process easier.  To set GL Accounts for sales information to send to:

 

  1. Go to Setup -> Tendering Codes (Figure 9-1).  The Tender Type window appears.

 

Figure 9-1

 

  1. Using the drop down menu, select a Tender Type you wish to assign a GL Account to, CS (Cash) for example.  (Figure 9-2)

 

Figure 9-2

 

  1. In the Button Example, you will see the tendering name.  (Figure 9-3)

 

Figure 9-3

 

  1. Assign a GL Account to the code.  (Figure 9-4)

 

Figure 9-4

 

  1. Click Update.
  2. Click OK.  (Figure 9-5)

 

 

Figure 9-5

 

  1. Repeat steps 2-5 until all tendering codes are assigned their desired GL Account.
  2. Click Exit when finished.

 

If you find a tendering code that you will not be using (Discover for example), you may delete it.  Remember that the GL Accounts that are assigned to Tendering Codes must exist inside the Simply Accounting company file or you will receive errors on the adapter when sending sales information into Simply Accounting.

 

Step 10:  Test the Integration: (top)

 

The integration for Simply Accounting is complete.  Before you continue on, though, it is highly recommended that you test the integration to make sure you didn’t miss a step:

 

  1. Backup Simply Accounting.
  2. Open AccuPOS Retail Point of Sale.
  3. Process a transaction and tender it to Cash.
  4. Close AccuPOS Retail Point of Sale.
  5. Reset the till by hitting the Z button at the upper left of AccuPOS Management and selecting the till to reset.
  6. Make sure the transaction posted to Simply Accounting as a sales receipt.
  7. Make sure that the funds posted to the correct GL Account.
  8. Restore Simply Accounting.

 

*For more information on processing transactions, please refer to the AccuPOS Operations Guide.

**For more information on resetting a till, please refer to the AccuPOS Retail Management Guide.