sync to quick books desktop

Susan S. shared this question 31 hours ago
Need Answer

We have over 400 future events in QBDesktop (through 12/2026). We are entering these orders in IO, but do not want them to come over (duplicate) when we sync. Many of these items have payments already tied to them (and funds deposited/reconciled to the bank).

I am not familiar with the options we will have with the sync. Can wd do our first sync based upon created date versus start (event) date?

Can I sync IO to a copy of QBD, the orders are flagged as being imported to QBD, then bring back my copy of QBD and the existing orders will not duplicate?

Can I select which orders/payments come over to QBD - at least initially?

Appreciate your support/thoughts and ideas - I'm new to THE community.

Comments (8)

photo
1

Hello Susan,

We will ask our developers what guidance or solutions they might be able to provide, and we will give you an update here as soon as possible. Thanks!

photo
1

Thank you

New Comment

sync to quick books desktop

Nick Twining

Hello Susan,

We will ask our developers what guidance or solutions they might be able to provide, and we will give you an update here as soon as possible. Thanks!

OPEN COMMENT IN BROWSER

Stop receiving notifications about this question

Powered by UseResponse

photo
1

Just to be sure we understand. you want to move your QBD (not from IO) to QBO and start syncing your IO account with the QBO account, but don’t want duplicates of the QBD leads?

photo
1

We are using QBD only.

QBD already has events invoiced throughout the upcoming year.

We don’t want to duplicate what is already in QBD (which may be marked as paid).

New Comment

sync to quick books desktop

Nick Twining

Just to be sure we understand. you want to move your QBD (not from IO) to QBO and start syncing your IO account with the QBO account, but don’t want duplicates of the QBD leads?

OPEN COMMENT IN BROWSER

Stop receiving notifications about this question

Powered by UseResponse

photo
1

Here is what we have learned:

The system is designed to avoid duplicating confirmed events. If the events in your QuickBooks Desktop already have associated invoice IDs (what we call quote_qbid), the integration should recognize them and not create duplicates in IO.

Our approach:

  1. Proceed with the initial sync.
  2. The system should recognize your existing, invoiced events in QuickBooks Desktop and avoid duplicating them in IO.
  3. Any new orders created directly in IO after the sync will then flow into QuickBooks Desktop.
  4. For payments made on the pre-existing QuickBooks events, these would need to be entered manually in QuickBooks Desktop, as the initial sync focuses on bringing over the order data. Subsequent payments made in IO on new orders should sync to QuickBooks.

Let me know if this makes sense, or if you have more questions!

photo
1

I think we’re getting there.

What makes an event have an associated invoice ID?  (marked in yellow below)  The invoice numbers in QBD were generated/integrated from RentMaster (our old rental software) and will be different than what has been created in  IO.  Not sure the system will recognize them as the same.

            We have started creating new events in IO for all events taking place in 2025 so that we have good sales figures and history for the full year.

I’m not worried about QBD updating IO.  I believe the sync will go from IO to QBD.  Am I understanding your statement below (blue) correctly? 

New Comment

sync to quick books desktop

Nick Twining

Here is what we have learned:

The system is designed to avoid duplicating confirmed events. If the events in your QuickBooks Desktop already have associated invoice IDs (what we call quote_qbid), the integration should recognize them and not create duplicates in IO.

Our approach:

  1. Proceed with the initial sync.
  2. The system should recognize your existing, invoiced events in QuickBooks Desktop and avoid duplicating them in IO.
  3. Any new orders created directly in IO after the sync will then flow into QuickBooks Desktop.
  4. For payments made on the pre-existing QuickBooks events, these would need to be entered manually in QuickBooks Desktop, as the initial sync focuses on bringing over the order data. Subsequent payments made in IO on new orders should sync to QuickBooks.

Let me know if this makes sense, or if you have more questions!

OPEN COMMENT IN BROWSER

Stop receiving notifications about this question

Powered by UseResponse

photo
1

Thank you for the additional info Nick.

When you refer to "associated invoice IDs (what we call quote-qbid)" not being duplicated in QBD by the sync, are you saying that I should modify all of my existing QBD invoices (405) to the new invoice number that IO is assigning to them to avoid duplication?

photo
photo
1

I believe that it will create duplicates if you didn’t use the lead ID as the reference in QBD. At that point you can delete your entries and use ours...of course you would want to update amounts paid. Or you can delete our entries and use the others and handle them manually. We suggest making a backup of your file, trying the integration to see if you like it, and if not, turn it off and use the backup.

photo
1

I was going to suggest the same thing as Nick. Get all of your leads and payments transferred from RentMaster to IO, let IO sync to QB, delete the old invoices from QB after confirming that the new ones are correct. The rest of the year will much more smoothly that way.

Congrats, Susan, on the switch to IO! I hope it's going well. We switched from RentMaster to IO in 2016. Our customer profiles and event records were a mess for a long time. I would do it much differently if I made the switch today. I wouldn't import anything. I would manually enter everything from the current year and skip the historical records.

photo
1

Casey - Can you elaborate on the fact that you wouldn't import anything? You wouldn't move any Rent Master current year invoices to IO? So IO and RM would not be in sync? If this is the case, is there a way of entering the old RentMaster data in IO so that it does not sync? We have many future dated invoices throughout 2025. Appreciate your thoughts/comments/suggestions.

photo
1

Do you need Rentmaster to be in sync with IO? Once you get everything moved to IO, you shouldn't need Rentmaster for anything other than to look back at past events.


Yes, you can enter the old Rentmaster events in IO without it syncing to QB. That is done by setting your QB sync date to 1/1/25, or whatever date you choose. It won't sync anything prior to that date.

I know it seems daunting to renter every lead for this year into IO manually, but there are a few advantages: 1) You have complete control of the data. You won't have anything sync to the wrong field, and your customer profiles and venues will be complete and accurate. 2) You will get a crash course on how to quickly enter and edit leads. You will eliminate the long learning curve that many people go through. 3) If you import your invoices from Rentmaster into IO, there will definitely be missing, incomplete, or incorrect data. Maybe it's only a single field that is messed up, but that will force you to go into every lead and make a change. You can avoid that by manually entering everything from the beginning.

One more thing. I don't know if this can be done differently today, but my Rentmaster leads that were imported into IO look like this. It took the total price of the lead and divided it evenly among each item. There were many other problems as well.

f5a8c3501484557cae3c987c23a8d871

photo
1

My major concern is IO syncing to QBD. QBD has invoices throughout 2025 already from RM. Some have payments on them already.

The invoices in QBD are dated through 12/2025 (over 400 of them with a future date). If I use a sync date of 12/31/2025, would that stop new invoices from coming over to QBD in the future? Or is that 12/31/2025 date a one time sync date. IE my initial sync date is 12/31/2025 - no data moves from IO to QBD.

Tomorrow's IO->QBD sync brings over a new invoice that might be dated 5/15/25??

Does that make sense?

photo
1

That's a good question. I don't know the answer. It's great that you are asking these questions before importing and syncing because you can make a mess of things very quickly. I would still lean toward syncing everything in 2025, and deleting the current invoices in QB that came from Rentmaster. However, if you can add the ID number to each of those existing invoices, as Nick suggested, that might be a great solution. I like his suggestion that you make a backup of your QB file, try the sync to see what happens, then make a decision on which route you want to take.

Chad Burkholder is the top IO guru. He is a user, like us, not an IO employee. I asked for his thoughts on this and he agrees that you should transfer everything manually from Rentmaster to IO. Importing is going to create a lot more work for you. 400 leads will go quickly once you get going. Do you know that there are two different layout options for IO leads? If you haven't seen it yet, switch to the "Concise view". It will be a lot quicker for entering these orders. It is in your worker profile if you use the Worker Module, General Preferences if not.

photo
1

Thanks Casey. We aren't syncing from RM to IO (entering manually). My concern is what dumps in to QBD from IO.

photo
1

Cool. Then I think you should make a backup of your QB file, choose a sync date, and see what happens. If you don't like it, delete that QB file and try again with a different sync date.


When you manually enter your leads into IO, including payments, then you sync to QB, you will have accurate invoices in QB going forward. The only part I can't wrap my head around without seeing it is what happens with the deposits. You will have a long list of payments to deposit in QB, but those have all been deposited already and matched up with your bank deposits. I can't quite figure out what to do with that. Do you delete the old deposits and do it all again? (that wouldn't take long) Do you delete the new deposits? I'm not sure what the answer is without having that situation in front of me.

photo
1

The deposits are a major concern of mine. We have quite a few payments that would be impacted.

photo
1

Here's a possibility for the deposit situation. Manually copy a lead from Rentmaster to IO. When you enter the payment that was made previously in Rentmaster, instead of copying all the payment details, just enter the amount, type of payment, and in the reference field type "Rentmaster". When the payments marked "Rentmaster" are synced to QB, delete those payments. If you have changed the invoice number in QB to match IO, any future payments will sync, so your QB invoices will be accurate.

photo
1

Thank you Casey. We can't be the first people that have these concerns. Wish there was some hard and fast information we could get our hands on. Fortunately and unfortunately, I believe we will be a larger customer of IO, so maybe we will help lay the tracks for new users.

photo
1

Happy to help. Have you joined the IO Users group on Facebook? That is the best place to crowdsource these issues. From what I have seen, most people who try QB sync do not take the time to understand what is going to happen, and they don't plan it out like you are. Many end up complaining that IO's QB sync made a mess of their books and they simply stop using it. They end up spending a lot of time and/or money on accounting. QB sync works great. It is a huge time saver. Once you get through these initial hurdles, it will be smooth sailing. I don't spend any time on accounting, and my books are ready for my tax guy to file taxes at the end of the year. We're probably on the larger end as well. What is your website? We operate two brands https://portlandpartyworks.com/ and https://wildbills.com/

photo
1

I will check out that FB group - thank you. I want to be on the positive side of the IO->QBD sync group. This is our web site Record-A-Hit | Event & Party Rental Attractions & Equipment Appreciate the positive comments and suggestions.

photo
1

For some reason, I've been on your site before. I don't know what would have brought me there. Maybe the LED dance floor? We have the same floor, but your page is a lot better than mine!

photo
1

we have a lot of cool stuff ;)

photo
Leave a Comment
 
Attach a file
You can't vote. Please authorize!