QuickBooks FAQs
Frequently Asked Questions
What data is pushed from FrameReady to QuickBooks?
-
QuickBooks Customer ID
-
Invoice Date
-
FrameReady item number
-
Description
-
QB Item
-
Quantity of the item
-
Unit Price
-
Payment Date
-
Payment Tender
-
Payment Amount
Will we be able to use class tracking to separate out invoices for different multi sites? That is a huge deal for those of us with multiple stores.
Invoice “Class" tracking has not been built into the current version of the Quickbooks integration. However, this could be added as a custom option. In order to use a "class," we would have to bring into FrameReady all classes set up in the customers Quickbooks (like we do with products and services) and set up a pulldown, on the invoice, to select that class. You have to reference the Quickbooks internal ID for this class and not just a name, so it has to match exactly what has been set up in Quickbooks.
Can I to push multiple invoices or do they have to be done one at a time?
The integration is currently set up to push one invoice at a time. Since you have to associate FrameReady line items with Quickbooks products and services, this part is a manual process.
Users may have different preferences on how to record their sales data; some will just put all sales into a "sales" bucket and others will want to break down the sales into specific product and services categories (this is why it is currently a manual process).
Another customization that can be offered: if a user wants to auto-select specific product and services. More automation around pushing multiple invoices at a time could be set up with more guidance on product and services.
Can I search for invoices that have not been pushed to make sure I have pushed all available invoices?
There is a ID saved to the FrameReady invoice from Quickbooks when the invoice is pushed successfully. You can search for = in this new field to find empty values (meaning an invoice wasn’t pushed to Quickbooks).
Is there any way to automate the push so it runs once daily (overnight)?
Same answer as above. A customization could be offered but some decisions needs to be made around product and services.
I already have 6,000 customers in QuickBooks, will this create duplicates?
There is a scripted process to import current Quickbooks customers (tested with up to 1,000 customers) and automatically attempt to match the Quickbooks customer to the FrameReady customer. The process matches on a couple different criteria (company name, address, etc.).
If a match is found, then the Quickbooks ID is saved on the FrameReady customer record. Once the ID is saved to the FrameReady customer, all transactions are associated with the Quickbooks customer (not duplicated).
But, if the process does not find a match for any reason (as a result of different spelling per system as an example), then the FrameReady customer won’t have a Quickbooks ID.
If a manual match is not made (possible with the integration set up), then, when any transactions are pushed from FrameReady, a duplicate customer could occur. The integration does not know the different between an unmatched customer or a new customer.
Please note: You are responsible for reviewing the imported QuickBooks Online data and linking it to your FrameReady data.
If I push a payment to QuickBooks, then realize it is incorrect and then fix it in FrameReady, can I click the Push to QuickBooks button again and have it update the previously pushed payment in QuickBook?
If you are using QuickBooks Online version, then that should work.
Can I change Invoice numbers to match?
Invoice numbers are auto-generated in FrameReady and are then pushed to QuickBooks as part of the invoice. Leaving the Invoice number at whatever FrameReady provides will keep things coordinated between FrameReady and QB in terms of the user experience.
If you have invoices in QuickBooks already, it may be that you simply need to have your FrameReady invoice number start at something higher so it doesn't conflict with invoices already in FrameReady.
If you are using QuickBooks for more than one company, then you should separate invoices by class.
© 2023 Adatasol, Inc.