BudgetEase Blog - Making YOU Profitable™

    Transitioning to eCommerce: A Bookkeeper's Perspective (Part 2)

    [fa icon="clock-o"] May 12, 2016 7:00:00 AM [fa icon="user"] Kathy Dise [fa icon="folder-open'] eCommerce

    Are you considering taking your business online?  An established distributor who now is moving into the eCommerce realm called me. She was concerned that QuickBooks Desktop would not be able to meet the needs of her WordPress website based eCommerce business. She is representing 11 manufacturers and never takes possession of the inventory. Customer orders will be for products from multiple companies. She wanted to know how she will process orders without purchasing an expensive program.

    Here are some of her concerns:

    When an order comes in, can QuickBooks generate a sales order that can be converted into multiple purchase orders?

    Yes.  

    1. Add your customer information for a day using the Add Multiple under the List Tab. You can cut and paste. 

      Screen_Shot_2016-05-11_at_9.00.32_PM.png

    2. List the preferred vendor for items to make the work flow seamless. 
      Enter the sale price correctly. 
      Items are Non-Inventory Parts. 
      Check the box that says I buy and sell this part.
      Items can also be updated quickly using the Add Multiple under the List Tab.

      Screen_Shot_2016-05-11_at_9.00.52_PM.png
    3. Create the Sales Order.
      Customer and Item are already listed in QB.
      Save then Create a Purchase Order.Screen_Shot_2016-05-11_at_9.01.02_PM.png
    4. Check Create purchase order for selected items.
      Drop ship to customer. Click OK.Screen_Shot_2016-05-11_at_9.01.14_PM.png
    5. Choose the first item being purchased. Click OK.Screen_Shot_2016-05-11_at_9.01.25_PM.png
    6. Here is your purchase order. Notice the Drop Ship Information.Screen_Shot_2016-05-11_at_9.01.37_PM.png

    My question to her was how and when will you be getting paid? In her case, the website will generate a payment through a merchant service. How does that money flow into her account?

    1. You start with an Invoice. A pop up will ask you if the invoice is based on a Sales Order. Check the correct Sales Order.
      Screen_Shot_2016-05-11_at_9.01.46_PM.png
    2. Another pop up asks if the client is paying for one or more item. This is a great feature for when you are collecting funds as goods are shipped. Check the correct box for your situation.Screen_Shot_2016-05-11_at_9.01.57_PM.png
    3. Your invoice is automatically generated. Save. Receive payment.Screen_Shot_2016-05-11_at_9.02.08_PM.png
    4. Include the reference number for the Merchant Charge. Save.Screen_Shot_2016-05-11_at_9.02.19_PM.png
    5. Now get the funds into your checking account.
      Go to your Merchant Services report.
      Find the amount deposited that day and the clients that make up the payment.
      In QuickBooks, go to Banking – Make Deposit.
      Click all the clients to make the amount agree with the Merchant Service Report (take fees at the next window).
      Click OK.
      Screen_Shot_2016-05-11_at_9.02.28_PM.png
    6. Choose the correct bank account the money is flowing into.
      Add the merchant fee if there is one as a negative number.
      Verify the amount of the deposit agrees to the amount that hits your bank account.Screen_Shot_2016-05-11_at_9.02.34_PM.png

    Don’t hesitate to call if you have any questions about this process.

    semi-annual quickbooks review checklist
    Kathy Dise

    Written by Kathy Dise

    Kathy has over 30 years experience helping small businesses succeed. As a commercial lender, commercialization expert and now as a QuickBooks diamond level advisor, Kathy understands the challenges small business owners face. Her experience helps business owners quickly accomplish their financial goals. As the owner of BudgetEase, Kathy works with clients to develop a plan to efficiently process 1,000s of small transactions so owners can make informed decisions. She lives in Shaker Heights, OH with her husband Ralph and enjoys golf, curling and walking in Cleveland’s fabulous Metro Parks.