TPS Cloud Axis and QuickBooks Online (QBO) Integration: Your Top Frequently Asked Questions (FAQs) Answered

Posted over 1 year ago by Giovanna Zisopulos

Post a topic
  • Pinned Topic
  • Topic is Locked
Un Answered
Giovanna Zisopulos
Giovanna Zisopulos Admin

The FAQs will provide answers to common questions about the synchronization process between TPS Cloud Axis and QBO.


1. What is the purpose of the TPS Cloud Axis and QuickBooks Online integration?

The integration streamlines accounting operations by syncing Accounts Receivable transactions and client information between TPS Cloud Axis and QBO.


2. What does the initial synchronization process do?

The initial synchronization process acts as the setup phase, where you define default mapping, linking TPS Workcodes to QBO Products and Services, Bank Accounts, Taxes, and connecting TPS Adjustment Increase and Decrease accounts to their corresponding QBO counterparts. Additionally, it allows you to map the Client List and A/R transactions. It's important to note that fully paid transactions are excluded from this synchronization. These default mapping set the foundation for maintaining a connection with QBO to ensure updates to transactions as they are paid, adjusted, or voided.

3. How does data mapping work in this integration with the line items within the invoices?
The firm determines the data mapping during the initial synchronization when the TPS Workcodes are mapped to corresponding QBO Products and Services, ensuring consistent and accurate data transfer on each item/WIP transaction that was billed within the invoice.

4. How does the synchronization process work in detail?

To sync your A/R transactions, you can create them in either TPS or QBO. Afterward, go to the Integrations - QuickBooks section in TPS and perform the Synchronization (export/import). Any new invoices made in either system will be synchronized according to the initial mapping of TPS Workcodes and QBO Products and Services/Chart of Accounts. We recommend creating the A/R transactions in TPS to avoid issues with any transaction types that TPS does not recognize.


5. Can I create invoices in both TPS Cloud Axis and QBO?

Yes, you can create invoices in both systems, but note that if you create an invoice in TPS, the PDF/Word version of the invoice will only be accessible within TPS. Only the line items will be displayed in the QBO invoice, based on the mapping that was done between the TPS Workcodes and the QBO Products and Services.

6. How do I ensure that the QBO - Online Payment link is included in the TPS invoice?

To include the QBO Online Payment link in your TPS invoice, start by creating the invoice using an invoice template that includes the QBO Online Payment link variable. TPS offers a default Invoice Template called 'QBO', you could customize the template and create a new one with your firm's logo and style preferences, keeping the QBO payment variable/link. Once the invoice is created, go to 'Integrations - QuickBooks' in TPS to sync and send the invoice to QBO.
In QBO, you will require to enable the online payment for the specific invoice to provide access to the QBO Payment link.


7. What limitations and restrictions should I be aware of?

QBO supports various transaction types not recognized by TPS since QBO was designed for various industries. Transactions such as credit memos, journal entries, deposits, and cheque expenses should be removed before the initial synchronization. These types of transactions will interfere with the synchronization process.

8. If Credit Memos are not supported by TPS, how do I record that type of transaction in TPS?

Credit memos should be recorded in TPS as 'Adjustments.' Please note that it's crucial to emphasize that if your organization uses credit memos in QBO, then TPS Cloud Axis synchronization will not function. Instead, those should be recorded as Adjustments in TPS.


9. Do I need a QBO backup system?

Yes, it's essential to have a QBO on-demand backup solution. A Rewind account is recommended to ensure data security and availability.

10. How can I perform daily/weekly synchronizations?

Navigate to the Integrations section in TPS under QuickBooks, then synchronize A/R transactions as often as required by adding a description and clicking "synchronize" to initiate the process. Review the sync history list to identify and address any issues.

11. What if synchronization fails for A/R transactions?

You can use the 'Retry Failed Items' option to review the errors reported, 'Retry' or 'Manually Remove Selected Entry' for items that previously failed.


12. How can I troubleshoot issues during synchronization?

In case of issues or warning messages, export the Sync History provided by TPS to view the specific messages generated by TPS or QBO regarding problematic transactions. If further assistance is needed, send the 'Sync History' Excel file to help identify and resolve the problem.


13. What is the difference between how TPS and QBO handle the 'Inactive' status for clients?

In TPS, marking a client as 'Inactive' adds a flag for filtering purposes and warning messages. The 'Inactive' status in TPS does not remove the Accounts Receivable (A/R) transactions associated with the client. However, in QBO, marking a customer as 'Inactive' goes a step further; it not only flags the client but also clears their AR balances, essentially treating them as if the customer was deleted from the system. Consequently, this may result in issues with the A/R totals not balancing.
It's crucial to determine whether the clients marked as 'Inactive' in QBO should still exist in your TPS client list or if those should be 'Deleted' from TPS or 'Exclude from Sync'.

14. Is it possible to restore a client that has been deleted in TPS Cloud Axis?
Yes, when a client is deleted in TPS, it is removed from the client list view. However, the system provides a filter option to 'View Deleted Clients' and restore them if necessary. If a client is resorted in TPS, it must be manually marked as 'Active' in QBO as well.


15. Why do sub-customers in QBO cause synchronization issues with TPS, and how can I resolve this problem?

Sub-customers in QBO can disrupt the synchronization process with TPS, leading to balance discrepancies. To resolve this issue, it's crucial to disable the use of Sub Customers in QBO. Manually remove any existing Sub Customers in QBO and carefully compare transactions between TPS and QBO to identify and address potential duplications, ensuring a smooth synchronization process.


16. When should I use the 'Exclude from Sync' feature in the TPS-QBO synchronization?

The 'Exclude from Sync' is utilized in various scenarios to maintain data integrity and streamline operations. This feature is only available to exclude customers.

  • Instances when you should use this feature: 
    • Nonchargeable Clients: Exclude clients who don't generate revenue for the firm, as they do not need to be synchronized with QBO. The synchronization process will not permit mapping nonbillable clients with QBO.
    • Duplicate Customers created by QBO: Exclude duplicate client records that may occur unintentionally in QBO to prevent discrepancies in balances.
  • Optional usage:
    • Prospects: Exclude prospects or potential clients who haven't been officially onboarded.
    • Inactive Clients: Exclude clients who are no longer active.


17. Is there a fee associated with the initial synchronization process?

Yes, the initial synchronization process incurs an additional fee of $350 for the first 2 hours of work. Any additional time beyond the initial 2 hours is billed at a rate of $150 per hour. The duration of this process may vary depending on the data. Before initiating the initial synchronization process, we send a checklist for the firm to review and set up everything required in QuickBooks Online. This checklist helps ensure that your firm reviews and proceeds with all the required data clean-up before the initial sync to ensure the process runs smoothly.


For more information and a comprehensive overview, watch the introductory video titled "Keep Your AR in Sync with TPS Cloud Axis Ultimate Subscription Plan and QuickBooks Online" or you could also review the TPS Cloud Axis and QuickBooks Online Synchronization - Checklist.

 Related Articles: 




Sincerely,

1-888-877-2231 - toll-free

0 Votes


0 Comments