{"id":218,"date":"2020-11-16T18:02:23","date_gmt":"2020-11-17T02:02:23","guid":{"rendered":"http:\/\/www.omtiblog.com\/reporterbase101\/?p=218"},"modified":"2026-04-14T10:04:28","modified_gmt":"2026-04-14T17:04:28","slug":"quickbooks-integrator","status":"publish","type":"post","link":"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/tools\/quickbooks-integrator\/","title":{"rendered":"Import RB9 data directly into <em>QuickBooks<\/em>"},"content":{"rendered":"<h6>Lesson #104<\/h6>\n<h5>Tools \u2013 QuickBooks Integrator function<\/h5>\n<p>If you use the popular accounting package\u00a0<em>QuickBooks<\/em>\u00a0you can <strong>import your RB9 data directly into <em>QuickBooks<\/em><\/strong> using QuickBooks Integrator eliminating the need to re-key financial data.<\/p>\n<p>With RB9\u2019s QuickBooks Integrator, you can:<\/p>\n<ul>\n<li><strong>Import contacts and resources<\/strong> into <em>QuickBooks<\/em> as customers and vendors.<\/li>\n<li><strong>Import invoices<\/strong> that were generated in RB9 into <em>QuickBooks<\/em> so that you can run consolidated financial statements.<\/li>\n<li><strong>Import payments and other transactions,<\/strong> including overpayments, into <em>QuickBooks<\/em> so that your bank deposits record and account balances will be accurate.<\/li>\n<li><strong>Import resource paychecks<\/strong>\u00a0into <em>QuickBooks<\/em> so that you can reconcile your bank account easily.<\/li>\n<\/ul>\n<p>QuickBooks Integrator works with either\u00a0<em>QuickBooks<\/em> online or desktop edition.<\/p>\n<h2>Set-up is 1-2-3<\/h2>\n<p>QuickBooks Integrator requires <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/setup\/set-preferences-for-using-quickbooks-integrator\/#quickbooks\">some set-up<\/a> before it can import RB9 data into QuickBooks for you. Before you can use QuickBooks Integrator, set up:<\/p>\n<ol>\n<li>Your RB9 business units\u2019 accounts to match your <em>QuickBooks<\/em> setup.<\/li>\n<li>System-wide defaults for QuickBooks Integrator.<\/li>\n<li>Secure remote access to your <em>QuickBooks<\/em>\u00a0(desktop version only) or test your connection (cloud version only).<\/li>\n<\/ol>\n<p>Instructions for all 3 tasks are included in the RB9 user guide, and RB Support can assist you if you need any help.<\/p>\n<p>After you have finished these 3 requirements, all you have to do is open <em>QuickBooks<\/em> then RB9\u2019s QuickBooks Integrator in that order and keep <em>QuickBooks<\/em> open while you are working in QuickBooks Integrator.<\/p>\n<h2>Importing entities<\/h2>\n<p>Instead of entering contacts\/customers and resources\/vendors into both RB9 and <em>QuickBooks,<\/em> enter them in RB9 then use QuickBooks Integrator to copy them into <em>QuickBooks.<\/em><\/p>\n<p>After entering contacts or resources in RB9, all you have to do to add them to your <em>QuickBooks<\/em> is open QuickBooks Integrator, select Customers to import RB9 contacts or Vendors to import RB9 resources, and leave the default date of today or enter a different date range. From the resulting list select all or some of the entities and import them into <em>QuickBooks<\/em> with a single click.<\/p>\n<p>If you need help finding entities in the list to import, you can sort the list by one or more columns in ascending or descending order (but if you change search criteria or exit the function RB9 will revert back to the default order). Export the list as an <em>Excel<\/em> spreadsheet or\u00a0a CSV (comma-separated values) file to save, print, share, or use in other applications.<\/p>\n<h2>Importing invoices<\/h2>\n<p>There are several reasons to import your RB9 invoices into <em>QuickBooks:<\/em><\/p>\n<ul>\n<li>If you operate multiple businesses and use <em>QuickBooks<\/em> to generate invoices for a business other than court reporting (e.g., a staffing business), you can import RB9 invoices into <em>QuickBooks<\/em> to run consolidated income statements.<\/li>\n<li>If you keep track of deposits with <em>QuickBooks,<\/em> you can eliminate duplicate entries of invoices and payments by importing that information directly from RB9.<\/li>\n<li>You can reprint RB9 invoices in <em>QuickBooks<\/em> format if needed.<\/li>\n<\/ul>\n<p>QuickBooks Integrator defaults to all invoices posted today. You can find invoices for a different post date and\/or invoices posted by one or more of your business units. As with importing entities, you can sort the list if needed and\/or export the list before selecting all or some of the invoices and importing them into <em>QuickBooks.<\/em><\/p>\n<p>And as it imports invoices RB9 automatically generates any missing data in <em>QuickBooks<\/em> (such as customers, chart of accounts, or items) so you don\u2019t have to worry about importing all of the supporting data for invoices one at a time. If any errors occur during import, that information will appear in the Error column in QuickBooks Integrator.<\/p>\n<h2>Importing payments<\/h2>\n<p>Instead of recording deposits manually in <em>QuickBooks,<\/em> you can import payment transactions directly from RB9 including payment processing fees. You just have to import invoices before importing payments since payments are applied to invoices in <em>QuickBooks.<\/em><\/p>\n<p>QuickBooks Integrator defaults to all payments posted today. Or you can find payments posted on a different post date. As with the other import categories, you can sort the list if needed and\/or export the list before selecting all or some of the payments and importing them into <em>QuickBooks.<\/em>\u00a0If any errors occur during import, that information will appear in the Error column in QuickBooks Integrator.<\/p>\n<h2>Importing credits &amp; journal entries<\/h2>\n<p>In addition to payments you can import other types of receivables transactions such as credits, duplicate payments, refunds, voids, and write-offs (but not debit memos or miscellaneous payments) directly from RB9. Like payments, you must import invoices before you can import these types of transactions since they are applied to invoices in <em>QuickBooks.<\/em><\/p>\n<p>As with payments QuickBooks Integrator defaults to all other allowable\u00a0receivables transactions posted today. Or you can find allowable\u00a0receivables transactions posted on a different post date. As with\u00a0the other import categories, you can sort the list if needed and\/or export the list before selecting all or some of the posted allowable\u00a0receivables transactions and importing them to <em>QuickBooks.<\/em> If any errors occur during import, that information will appear in the Error column in QuickBooks Integrator.<\/p>\n<h2>Importing resource payroll checks<\/h2>\n<p>While you can <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/payables\/print-export-or-direct-deposit-paychecks\/\">print resource payroll checks directly from RB9<\/a>, instead have <em>QuickBooks<\/em> print them using your RB9 data. This way, in addition to printing the checks, <em>QuickBooks<\/em>\u00a0also deducts the amounts from your checking account since reconciling your bank account can only be done in <em>QuickBooks<\/em>, not RB9.<\/p>\n<p>When preparing to import paychecks QuickBooks Integrator defaults to today as the pay date. You can select a different pay date. The list of resources eligible to be paid in the specified payroll also includes their check amounts. As with the other import categories, you can sort the list if needed and\/or export the list before selecting all or some of the\u00a0resources and importing their paychecks to <em>QuickBooks.<\/em> You can also\u00a0enter the common text that will appear in the Memo field on each check before sending the list to <em>QuickBooks<\/em>.<\/p>\n<p>As with invoices, RB9 automatically generates any missing data in <em>QuickBooks<\/em> (such as vendors) as checks are imported. You do not have to worry about importing all of the supporting data for checks one at a time. If any errors occur during import, that information will appear in the Error column in QuickBooks Integrator.<\/p>\n<p>(While this method is faster, you can still export payroll checks via a QuickBooks IIF file from <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/payables\/print-export-or-direct-deposit-paychecks\/\">Print Checks<\/a> to import into <em>QuickBooks.)<\/em><\/p>\n<p><em>NOTE: This is an RB9 Standard-only function. It is not included in RB9 Lite.<\/em><\/p>\n<p><strong>TL;DR: Import RB9 entities, invoices, paychecks, and payment transactions into <i>QuickBooks.<\/i><\/strong><\/p>\n<h4>RB9 concepts in this lesson<\/h4>\n<p><strong>Business Unit (BU):<\/strong>\u00a0One of your company\u2019s revenue centers or any\u00a0entity in your business that you want to track separately.<\/p>\n<p><strong>Contact:<\/strong> Person who works for a firm you do business with.<\/p>\n<p><strong>Resource:<\/strong> Person or thing that provides your business with a service \u2014 such as reporters.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Import RB9 entities, invoices, paychecks, and payment transactions into this popular accounting software <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/tools\/quickbooks-integrator\/\">&hellip;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,226,27],"tags":[228,98,3,28],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-function","category-lesson","category-tools","tag-emailed-lesson","tag-quickbooks-integrator","tag-rb9-standard","tag-tools"],"_links":{"self":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":0,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}