Results 1 to 4 of 4
  1. #1
    Involute is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2023
    Posts
    2

    Access and Quickbooks

    I'm starting a small business from scratch, so I have the luxury of thinking through my software stack, rather than adapting to a legacy system. I'm going to have a Shopify storefront which will export sales data in CSV. I'll need to import this into some program for managing and tracking the business. I'll also need to import at least some of it into Quickbooks since that's what the bookkeeper will want. I'd be happy to do everything in Quickbooks (though it's far from ideal), except each order will have some image files associated with it and I won't be able to keep track of those within Quickbooks. So I'm thinking of importing each order into both Access and Quickbooks. That seems like a lot of effort, though, with associated opportunities for error. So I'm also thinking of just importing into Access and then exporting "directly" to Quickbooks. Is that possible?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I've never used it, but my understanding is that you can work with Quickbooks data from Access:

    https://quickbooks.intuit.com/app/ap..._Online/en-us/

    You might also check the "Similar Threads" below.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    I gave a couple of clients who do just that, import to access from Shopify, Amazon and other sales channels, then export (in their case) accounting Data to Xero. So certainly possible

  4. #4
    Involute is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2023
    Posts
    2
    Quote Originally Posted by pbaldy View Post
    I've never used it, but my understanding is that you can work with Quickbooks data from Access:

    https://quickbooks.intuit.com/app/ap..._Online/en-us/

    You might also check the "Similar Threads" below.
    Thanks for the tip. That product gets pretty poor reviews, unfortunately. On the other hand, I've since discovered there's a way to export directly from Shopify to Quickbooks. Since it's an Intuit product, I'm hoping I can trust it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access to Quickbooks Connection: QODBC
    By davibus in forum Access
    Replies: 1
    Last Post: 09-09-2014, 03:10 PM
  2. Exporting Access to Quickbooks
    By tpeila in forum Import/Export Data
    Replies: 1
    Last Post: 03-27-2013, 03:31 PM
  3. Linking Access 2010 to Intuit quickbooks
    By JeremyPSU in forum Access
    Replies: 2
    Last Post: 12-16-2010, 04:04 PM
  4. Replies: 1
    Last Post: 08-22-2010, 12:25 PM
  5. Syncing Quickbooks and Access
    By nomij in forum Import/Export Data
    Replies: 0
    Last Post: 08-22-2008, 07:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums