Overview of the Invoice Reconciliation Report
29 steps
2 minutes
1
Navigate to Brokerage Engine.
Generate the Report
2
Click "Accounting" to navigate to the module.
3
Click the "Reports" tab.
4
Click "Subledger Reporting"
5
Click the "Invoice Reconciliation" option.
6
The Invoice Reconciliation Report will populate.
7
The date range can be determined by the options from the dropdown menu.
8
Or set the date using the small calendar icons.
9
Click the "Generate" button.
10
The report will generate with the dates provided. The blue heading indicate the criteria on the Agent Facing side of Brokerage Engine, and the yellow heading the criteria in Accounting.
Breakdown of Fields
11
- 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.
12
- Agent Facing Amount - the amount of the invoice in the front-end of the platform. - Agent Facing Balance - the balance of the invoice in the front-end of the platform. - Agent Facing Status - the status of the invoice in the front-end of the platform.
13
- 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.
14
Accounting Match - it displays two statuses. If the Accounting Match is "true", then the invoice created in the agent-facing 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.
Search for Invoices
15
Click the "Search Invoice#" field to locate an invoice by typing the invoice number.
16
Use the "Office" dropdown menu to filter the results by office.
17
Use the "Bill To" dropdown menu to filter the results by Agent.
18
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.
Fixing a Common Sync Error
19
Force synching an Invoice that has a false Accounting Match status will result in an error message by the system.
20
As per the Error! message, the Invoice did not sync because there is an invoice in the Accounting Platform that already exists with that invoice number.
21
On the report, click on the Amount of the Invoice that failed to sync. This will navigate you to the invoice on the Agent Facing side of Brokerage Engine.
22
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
23
The Sync Log shows the failed sync activity of the Invoice.
24
When clicking on "\[BE\] - Import Invoice", the error that is causing the sync failure will display. In this case, the invoice number has already been used for an invoice that was manually created in Accounting.
The existing invoice in Accounting has been adjusted so as to allow the Agent Facing invoice to sync.
25
Navigate back to the Invoice Reconciliation Report and force sync the Invoice.
26
Click "OK"
27
Click "OK"
28
The Accounting Match will now show as "true".
29
The "View in Accounting" button will now display in the Agent Facing side of Brokerage Engine.
Overview of the Invoice Reconciliation Report
29 steps
2 minutes
1
Navigate to Brokerage Engine.
Generate the Report
2
Click "Accounting" to navigate to the module.
3
Click the "Reports" tab.
4
Click "Subledger Reporting"
5
Click the "Invoice Reconciliation" option.
6
The Invoice Reconciliation Report will populate.
7
The date range can be determined by the options from the dropdown menu.
8
Or set the date using the small calendar icons.
9
Click the "Generate" button.
10
The report will generate with the dates provided. The blue heading indicate the criteria on the Agent Facing side of Brokerage Engine, and the yellow heading the criteria in Accounting.
Breakdown of Fields
11
- 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.
12
- Agent Facing Amount - the amount of the invoice in the front-end of the platform. - Agent Facing Balance - the balance of the invoice in the front-end of the platform. - Agent Facing Status - the status of the invoice in the front-end of the platform.
13
- 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.
14
Accounting Match - it displays two statuses. If the Accounting Match is "true", then the invoice created in the agent-facing 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.
Search for Invoices
15
Click the "Search Invoice#" field to locate an invoice by typing the invoice number.
16
Use the "Office" dropdown menu to filter the results by office.
17
Use the "Bill To" dropdown menu to filter the results by Agent.
18
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.
Fixing a Common Sync Error
19
Force synching an Invoice that has a false Accounting Match status will result in an error message by the system.
20
As per the Error! message, the Invoice did not sync because there is an invoice in the Accounting Platform that already exists with that invoice number.
21
On the report, click on the Amount of the Invoice that failed to sync. This will navigate you to the invoice on the Agent Facing side of Brokerage Engine.
22
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
23
The Sync Log shows the failed sync activity of the Invoice.
24
When clicking on "\[BE\] - Import Invoice", the error that is causing the sync failure will display. In this case, the invoice number has already been used for an invoice that was manually created in Accounting.
The existing invoice in Accounting has been adjusted so as to allow the Agent Facing invoice to sync.
25
Navigate back to the Invoice Reconciliation Report and force sync the Invoice.
26
Click "OK"
27
Click "OK"
28
The Accounting Match will now show as "true".
29
The "View in Accounting" button will now display in the Agent Facing side of Brokerage Engine.
