Doel van het verslag
Alle betalingen laten zien die zijn toegerekend binnen een specifieke periode, om behandelaars te betalen voor werk dat ze hebben gedaan en ontvangsten (betalingen) te tonen die zijn toegewezen aan facturen (en vice versa).
We bevelen dit verslag aan om behandelaars te betalen, want de behandeling is voltooid, de betaling is gedaan en de factuur en betaling zijn aan elkaar toegerekend. Het verslag geeft informatie over:
Totaal huidige ontvangsten.
Totaal aan facturen toegerekende ontvangsten.
Totaal ontvangsten die niet zijn toegerekend (voorgeschoten/vooraf betalingen).
Dit verslag maakt deel uit van de groep 'Betalingen’ en heeft de volgende beschrijving: Hiermee kunt u berekenen hoeveel aan medewerkers of PAs/hygiënisten moet worden betaald. Dit verslag bevat de nettobetalingscijfers nadat betalingscorrecties zijn toegepast.
We raden aan om eerst ervoor te zorgen dat alle betalingen aan facturen zijn toegerekend (zie ook Open transactie overeenstemming verslag).
Verslag uitvoeren
Ga naar Administratie - Verslagen.
Dubbelklik op ‘Toegerekende betalingen’.
Indien gewenst selecteer de behandelaars.
Vul de gewenste datums in.
Selecteer welk overzicht u wilt hebben:
Vink ‘Eenvoudig overzicht’ aan als u alleen een overzicht van het totaal per behandelaar wilt zien.
Vink ‘Overzicht op tandarts patiënt’ aan als u een overzicht wilt hebben van toegerekende betalingen voor patiënten van andere behandelaars (dit is de aanbevolen optie).
Vink ‘Overzicht op wie is betaald’ aan voor een overzicht van toerekeningen aan behandelaars aan wie de betalingen zijn gedaan.
Selecteer of u een alleen details, alleen samenvatting of details en samenvatting wilt hebben.
Vink ‘Verberg voorgeschoten betalingen’ aan als u voorgeschoten betalingen niet uitbetaald aan de behandelaars en behandelaars alleen betaald voor betalingen voor behandelingen die zijn voltooid.
Klik vervolgens op ‘Afdrukken’, ‘Voorbeeld’, ‘E-mail’ of ‘Exporteren’.
Voorbeeld van verslag
Kolommen
Datum | Datum en geplande afspraaktijd. |
Lengte | Geplande afspraakduur. |
Example Page 1:
Example Page 2:
The option is also available to include advanced payments (deposits).
This report can be run to include full details for each allocation (i.e Date of the invoice and receipt and how much of each has been allocated together)
Interpreting the Allocated Payments Report
To view the detail of Advance payments now allocated in this reporting period
In the Details section of the report, an Advanced Payments Now Allocated section details the advance payments that have been allocated in this reporting period.:
Provider and Payor Type shown against Invoices
This is visible in the Details section of the report. It shows where the payment has been allocated. For example:
In the above example, payment was temporarily to an Unknown Payor, but was then allocated to a Private invoice.
To track the total figure of Advance Payments now allocated within a reporting period:
See the last page of the report, under the Notes section:
Receipt paid to one Provider but allocated to another (Transfer Provider column):
When a receipt shows as being paid to one Provider but allocated to another, it indicates that when the payment was originally taken, it was under the first Provider (RJB in the example above) but then once the treatment was done, it was transferred to the correct Provider (AG in the example above).
NOTE: The Transfer Provider column is irrelevant if you bank all receipts into a single bank account.
Using a flat percentage for allocated receipts vs using different percentages:
The above difference also applies to Advanced Payments, when these are configured to be displayed:
Advance Payment has been allocated and shows as a negative figure, so that it is not paid to the Provider twice
In a period where an Advance Payment has now been allocated, it will show as a negative figure in the Advance Payments section, and a positive figure in the Total Allocated To section, which results in the figures cancelling each other out for the period. For practices that pay on advanced payments, this ensures that once the money is allocated, it is not paid to the Provider twice.
If Simple Summary is selected in the Report Options window:
The detail section of the report has the following detail of current receipts used to pay for invoices or advance payments, broken out by receipt:
Date | The date that the receipt was processed. |
Details | This column shows: the receipt number, the patients name, the date of the invoice and the invoice number that the receipt relates to. It will also show any adjustments that may have been made to receipts or invoices. |
Trns Prov. | Entries in this column show the initials of the provider who created the invoice. This is who the receipt has been processed to, and therefore the payment has been allocated to. |
Note: In order to get complete and accurate allocation figures for each specified provider, the report must include everything that is allocated to or from that provider, including receipts and adjustments. Therefore this column may sometimes contain codes of providers who were not included in the selection criteria, if they were the provider who created the invoice or adjustment. | |
Payor | Displays the payor for the treatment. |
Receipt | The total value of the receipt. |
Invoices: | |
Adjusts | Shows any adjustments such as refunds that were made. This does not include receipt adjustments. |
Payor | This shows the amount the payor has paid. |
Patient | This shows the amount the patient has paid. |
Advance Payment | This shows only if any advance payments were made, and the Hide Advance Payments option is not ticked. |
Summary
After the main body of the report prints, a second section is printed, which shows a summary for the report, broken down by provider into allocations and advances. For each provider, all payor types are listed. For each of these payors it shows any adjustments, payor invoices, patient invoices, and a total, for both the allocated and advance payment sections of the summary.
This part of the report will include the following information:
Receipts totalling | The total for ALL receipts for the selected period. |
Below this are the summary figures for the allocations and advances, by payor, per provider. | |
Payor | This column shows the payor, including Private and Unknown. |
Invoice Adjusts | Adjustment totals for each provider/payor combination. |
Payor Invoice | This shows the total the payor has paid |
Patient Invoice | This shows the total of all patient contributions that have been paid towards payor-covered treatment. |
Advance Payment | Any advance payments made to a provider are totaled by payor. |
Totals | This shows the total amount of all payments and adjustments that have been made to a provider, broken down by payor. |
If “Summarise by Patient's Dentist” is selected in the report options window:
Both the detail and summary sections are the same as for the Simple Summary option above, except there is a Pats Prov. column that in each of the detail lines shows who the patients provider was.
If “Summarise By Who Got Paid” is selected in the report options window:
The detailed section is the same as the Simple Summary option above.
The summary section is the same as the Simple Summary option above, except it has an extra column for Trns Provider and the report is broken down by the provider to whom the payment for treatment was allocated, and shows under this the providers who were actually paid for the treatment. It may include providers who were not included in the selection criteria, if those providers made or received allocations from one of the specified providers.
GST reporting:
Even zero-value rows are displayed:
The Detailed reporting option will always display Invoice Numbers:
So long as a Receipt is unallocated, that Payor will be shown as 'Unknown':
Payor Type 'Open Balance'
Payor Type 'Mixed'
Refund Adjustments are shown under Advanced Payment:
This also applies to an advanced payment that is partially refunded due to the treatment not yet being completed.
Transfers between Providers or Payors:
Transfers usually occur when there has been an adjustment or an overpayment.
If an advance payment is received to Provider A and the subsequent treatment is done by Provider B, and the invoice and receipt are allocated to each other, the transfer will show in the Transfers between Providers or Payors section:
Patient to Patient receipt transfers where the receiving patient has a credit balance which is unallocated:
For Patient to Patient receipt transfers where the receiving patient has a credit balance which is unallocated, the Payor column will show as Unknown. The original receipt from the transferring patient will stay as their original Payor Type.
Patient to Patient receipt transfers when the receipt is fully allocated:
For Patient to Patient receipt transfers when the receipt is fully allocated, the Payor column will show the applicable Payor from the invoice to which the payment was allocated.
Patient to Patient receipt transfers when the receipt transfer is to multiple invoices with more that one Payor:
For Patient to Patient receipt transfers when the receipt transfer is to multiple invoices with more than one Payor, the Payor column will show as Mixed.
Write Offs
Only write offs that are written off to a different provider from the original invoice Provider will show on the report, in the Transfers Between Providers or Payors section. Write offs to the same Provider as the original invoice do not involve receiving a payment and therefore should not appear.
Write offs will always have the same Payor and Provider as the invoice they are writing off, even if write offs are created for a batch of mixed Payor invoices.
Report Notes - "Unknown" Payors
You may see a line in the Notes section of the report:
The payor will be 'unknown' when the payment is not fully allocated at the time the payment was taken.
The receipt should not change from one report period to the next, so the report always uses the posting date position for the receipt as its starting value.
Consequently, the payor can remain 'unknown' even when the payment is later fully allocated.
Voorbeeld Pagina 1:
Voorbeeld Pagina 2:
Het rapport Toegewezen betalingen interpreteren
Om de details te bekijken van vooruitbetalingen die nu zijn toegewezen in deze rapportageperiode
In het gedeelte Details van het rapport worden in het gedeelte Vooruitbetalingen nu toegewezen de voorschotten beschreven die in deze rapportageperiode zijn toegewezen.:
Aanbieder en betalertype weergegeven bij facturen
Dit is zichtbaar in het gedeelte Details van het rapport. Het laat zien waar de betaling is toegewezen. Bijvoorbeeld:
In het bovenstaande voorbeeld was de betaling tijdelijk aan een onbekende betaler, maar werd vervolgens toegewezen aan een privéfactuur.
Om het totale aantal vooruitbetalingen te volgen dat nu binnen een rapportageperiode is toegewezen:
Zie de laatste pagina van het rapport, onder de sectie Opmerkingen:
Ontvangstbewijs betaald aan de ene aanbieder maar toegewezen aan een andere (kolom Transferaanbieder):
Wanneer een ontvangstbewijs wordt weergegeven als betaald aan de ene aanbieder maar toegewezen aan een andere, geeft dit aan dat toen de betaling oorspronkelijk werd gedaan, deze onder de eerste aanbieder was (RJB in het bovenstaande voorbeeld), maar toen de behandeling eenmaal was voltooid, werd deze overgedragen