R2 Core
R2 Core
Breadcrumbs

R2 Posting Guide

Table of Contents

QuickBooks Integration Steps

Exporting Invoices from R2 To QuickBooks

This process is done from the invoicing module in the receivables tab.

  1. Create a new batch and add invoices to be posted

  2. In the Invoicing Module go to Actions > Post Batch

image-20240606-180458.png

  1. The Post Batch dialog box will open. Select the path to the Pending folder where the export files will be saved and select Peachtree for Invoice Format. (Although this is QuickBooks integration, the Peachtree files are QuickBooks compatible)

image-20240606-180528.png

  1. The export files R2 will create are Customer.csv and Sales.csv

Integration

  1. Run the R2QB2.exe

  2. The following window will open

image-20240606-180615.png

  1. Click the Process R2 to QuickBooks button.

The QuickBooks integration will run. It will process the Customer.csv and Sales.csv files. If the integration is successful it will move the files to the Processed folder. If the integration fails it will move the files to the Failed folder.

When the integration finishes successfully you will be able to see the invoices in QuickBooks.

Exporting Payments from R2 to QuickBooks

Step #1

  1. This process is done from the invoicing module, in the payments tab.

  2. Create a batch and add payments to be posted.

  3. In the Invoicing Module go to Actions > Post Batch

image-20240606-180735.png

  1. The Post Batch dialog box will open. Select the path to the Pending folder where the export files will be saved and select Peachtree for Payment Format. (Although this is QuickBooks integration, the Peachtree files are QuickBooks compatible)

image-20240606-180806.png

  1. The export file R2 will create is payments.txt

Step #2

  1. This process is done from the invoicing module by clicking on the Extract Customer Details icon image-20240606-180848.png

  2. The Post Batch dialog box will open. Select the path to the Pending folder where the export files will be saved and select Peachtree for Invoice Format. (Although this is QuickBooks integration, the Peachtree files are QuickBooks compatible)

image-20240606-180909.png

  1. R2 will create the export file Customer.csv

Integration

  1. Go to the Pending folder

  2. Open the Customer folder

  3. Copy the Customer.csv file to the Pending folder

  4. Run R2QB2.exe image-20240606-181020.png

  5. The following window will open:

image-20240606-181044.png

  1. Click the Process R2 to QuickBooks button.

The QuickBooks integration will run. It will process the Customer.csv and Sales.csv files. If the integration is successful it will move the files to the Processed folder. If the integration fails it will move the files to the Failed folder.

When the integration finishes you will be able to see the payments in QuickBooks.

Exporting Invoice Payments from QuickBooks to R2

  1. After applying payments in QuickBooks run R2QB2.exe image-20240606-181240.png

  2. The following window will open

image-20240606-181255.png

  1. Click on Process QuickBooks to R2

  2. An Export1 and Export2 file will be created in the location you set when setting up the R2QB2.exe

  3. In R2 go to the Invoicing Module>File>Import Invoice Payment Details

image-20240606-181330.png

  1. Select the location of Export1

image-20240606-181412.png

  1. Select the location of Export 2

image-20240606-181437.png

  1. Click OK

  2. The payments will be applied to the invoices in R2 and the customer balance due will be updated.