Hide Matching Invoices 
No
Yes
Invoice#	Office	Bill To	Invoice Date	LSS
Amount	LSS
Balance	LSS
Status	Accounting
Amount	Accounting
Balance	Accounting
Status	Accounting
Match	Action
BEC-10408	San Antonio - 1202 N. Flores St	Alisha Smith	04/10/2023	$25.00	$25.00	Overdue				false	
BEC-10410	San Antonio - 1202 N. Flores St	Elizabeth Andrew	04/11/2023	$100.00	$100.00	Overdue				false	
BEC-10415	San Antonio - 1202 N. Flores St	Amy Agent	04/16/2023	$52.00	$52.00	Overdue				false	
BEC-10417	San Antonio - 1202 N. Flores St	Ronee Nance	04/17/2023	$100.00	$100.00	Overdue				false	
BEC-10427	San Antonio - 1202 N. Flores St	Alisha Smith	04/24/2023	$21.00	$0.00	Paid				false	
BEC-10431	San Antonio - 1202 N. Flores St	Amy Agent	04/26/2023	$0.07	$0.07	Overdue				false	
BEC-10432	San Antonio - 1202 N. Flores St	Leyland Knapic	04/28/2023	$222.00	$222.00	Overdue				false	
Showing 1 to 7 of 7 entries (filtered from 22 total entries)
Download as CSV / Excel
Previous
1
Next

The date range can be determined by the options from the dropdown menu, or by the date fields.

The report will generate with the dates provided. The blue heading indicate the criteria on the Brokerage Connect platform, and the yellow heading the criteria in Accounting.

Invoice#
Office
San Antonio - 1202 N. Flores St
Bill To
Brian Zhang
Robert Dullnig
Carole Singer
Marsha Mellow
Justin Thyme
Amy Agent
Thayer Williams
Linda Stewart
Kellan Stephens
John Jones
John Agent
Travis Saxton
John Jones
Andrew Agent
Samanta Maisuls
Cici Chen
Michelle Jean
Dawn James
Lynn Alan
Ann James
Andrew Joseph
Ann Joseph-Feeley
Dawn James
Ann James
Elizabeth Zapata
Leyland Knapic
Anthony Morgan
Marianne Davidson
Lyn Grace
Lamar Leilani
Lamar Leilani
Nicolas Ortega
Catherine Dove
Cici Branch manager
Ronee Nance
Elizabeth Andrew
Nicholas Carmine
Renee Liam
Tucker Thayer
Sierra Yvonne
Alisha Walker
Alisha Smith
Joseph Martin
Luca Maisuls

Invoice # - it is the autogenerated reference number of the invoice.

Office - it is the office tied to the invoice.

Bill To - the Agent (Customer) that is billed by the invoice.

Invoice Date - the date the invoice was created.

LSS Amount - the amount of the invoice in the Connect platform.

LSS Balance - the balance of the invoice in the Connect platform.

LSS Status - the status of the invoice in the Connect platform.

Accounting Amount - the amount of the invoice in the Accounting platform.

Accounting Balance - the balance of the invoice in the Accounting platform.

Accounting Status - the status of the invoice in the Accounting platform.

Accounting Match - it  displays two statuses. If the Accounting Match is "true", then the invoice created in the Connect platform synced successfully to the Accounting platform. If the Accounting Match is "false, then the sync log for the invoice needs to be reviewed. Any errors will need to be revised, and then the invoice will sync. 

The Action column has a force sync button to expedite the sync of invoices. If the invoice is not force synced, then it will automatically feed on the next scheduled sync. 


You can search for an invoice by typing the invoice number on the text field.

HOME
REPORTS
SUBLEDGER REPORTING
INVOICE RECONCILIATION
INVOICE RECONCILIATION REPORT
Custom
Current Month
Current Quarter
Current Year
Last Month
Last Quarter
Last Year
Last 365 Days
Custom
From:To:
Generate
INVOICE RECONCILIATION REPORT
Invoice#
Office
San Antonio - 1202 N. Flores St
Bill To
Brian Zhang
Robert Dullnig
Carole Singer
Marsha Mellow
Justin Thyme
Amy Agent
Thayer Williams
Linda Stewart
Kellan Stephens
John Jones
John Agent
Travis Saxton
John Jones
Andrew Agent
Samanta Maisuls
Cici Chen
Michelle Jean
Dawn James
Lynn Alan
Ann James
Andrew Joseph
Ann Joseph-Feeley
Dawn James
Ann James
Elizabeth Zapata
Leyland Knapic
Anthony Morgan
Marianne Davidson
Lyn Grace
Lamar Leilani
Lamar Leilani
Nicolas Ortega
Catherine Dove
Cici Branch manager
Ronee Nance
Elizabeth Andrew
Nicholas Carmine
Renee Liam
Tucker Thayer
Sierra Yvonne
Alisha Walker
Alisha Smith
Joseph Martin
Luca Maisuls
Hide Matching Invoices 
No
Yes
Invoice#	Office	Bill To	Invoice Date	LSS
Amount	LSS
Balance	LSS
Status	Accounting
Amount	Accounting
Balance	Accounting
Status	Accounting
Match	Action
BEC-10340	San Antonio - 1202 N. Flores St	Amy Agent	01/25/2023	$531.25	$531.25	Overdue				false	
Showing 1 to 1 of 1 entries (filtered from 74 total entries)
Download as CSV / Excel
Previous
1
Next

Additionally, you can search by Office by selecting from the dropdown menu.

You can pull all the invoices that belong to an Agent by selecting their name from the dropdown menu under "Bill To".

The toggle key for "Hide Matching Invoices" can be selected to "No" and "Yes", in order to direct the system whether to display Invoices that have been synced to the Accounting platform and have a match.

Force synching an Invoice that has a false Accounting Match status will result in an error message by the system.

As per the Error! message, the Invoice did not sync because the Invoice has an Account that does not exist in the Accounting Platform.

On the report, click on the Amount of the Invoice that failed to sync. This will navigate you to the invoice of the Connect (LSS) platform.

The "View in Accounting" button is missing.

In order to view the sync log of an Invoice add "/synclog" to the end of the Invoice URL.

The Sync Log shows the failed sync activity of the Invoice.

When clicking on "[BE] - Import Invoice", the error that is causing the sync failure will display. In this case, the Marketing Item was created with Account 6012, which is an Account that was later renamed.

The Marketing Item has been updated with the correct account.

Navigate back to the Invoice Reconciliation Report and force sync the Invoice.

The Accounting Match will now show as "true".

The "View in Accounting" button will now display in the Connect (LSS) platform.

View in AccountingDownload PDF
 Edit Invoice
Toggle Dropdown

The report compares the invoices in the Brokerage Connect (LSS) and Accounting platforms. The fields include the invoice amount, balance, and status. Additionally, it will provide the user with information on the sync status of the invoice, and a quick sync tool.

Overview of the Invoice Reconciliation Report

Generate the Report

Breakdown of fields

Search for Invoices

Fixing a Common Sync Error