Post Reply 2 posts Page 1 of 1
QuickBooks Data Transfer
  • jwol
    New User
    New User
    Posts: 23
    Joined: Sat Dec 31, 2011 11:25 am

    QuickBooks Data Transfer

    by jwol » Mon Jul 02, 2012 11:13 am

    Hate to be bothersome but...
    The data transferred (sales export) from RetailEdge into QuickBooks is simply a block of data going in as income with only taxes and dates separated out. There's no descriptive information in this sales income such as item, customer, quantity, department, class, etc.

    We desperately need the ability for QB to separate certain income. The reason is that our retail store has a department that is owned and rented by another. They sell wine and we maintain their inventory, bar coding, costs, prices and sales on RE. We and they both produce sales tickets containing both OUR products and THEIRS so that our customers can use a single payment for both. We have given their wine products unique departments and classes for reporting purposes in RE and we can fairly easily separate their sales from ours. However when we export to QB the sales are all lumped together as income with no separation.

    Is there ANY way to "fake out the system" so that we can separate these wine sales (and taxes) from our total when we do our daily export to QuickBooks? The QuickBooks tab on the modify workstation parameters is the only place known to affect the export.

    Thanks.
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1290
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    Re: QuickBooks Data Transfer

    by RetailEdge Moderator » Mon Jul 02, 2012 11:48 am

    No bother. A couple of things:

    RetailEdge does have the ability to break out sub accounts of sales by RetailEdge department. You just need to setup the proper sub-account in Quickbooks so that RetailEdge knows where to send the data. You can setup these sub-accounts in RetailEdge by editing the department from the Inventory | Department menu item.

    We don't export detailed information other than the lump sum account adjustments for a number of reasons. But primarily because QuickBooks has a limit on the amount of items/sales etc. that can be put in the program. We would quickly exceed this limit if we dumped all the information from RetailEdge into QB.

    Hope this helps.
Post Reply 2 posts Page 1 of 1

Who is online

Users browsing this forum: No registered users and 18 guests