Verified on release 3.0.74.2 of “Accounting for Kazakhstan” (version 3.0).
A counterparty sent you a work completion certificate for 580 000 ₸, while your accounting records show 560 000 ₸ under the same contract. To avoid opening each document manually, generate the “Information on Work Completion Certificates” report and specify the period and counterparty. The report will display a list of certificates with amounts excluding VAT, VAT amounts, and totals. This allows you to quickly find a document in which the rate applicable before 2026 was used instead of the current rate of 16 %.
It is important to clarify from the outset that this is a report intended for viewing and reconciling certificates that have already been entered. Below, “completion” means configuring the period, filters, groupings, and the data to be displayed. If a discrepancy is found in a report row, the correction is made in the corresponding source document.
1. Purpose
The report displays a list of work completion certificates and certificates for services rendered for the selected period. Depending on the settings, it can show the counterparty, contract, document, date, amount excluding VAT, VAT amount, and total amount.
The report is used for reconciliation with a counterparty, monitoring service revenue, comparing documents with tax accounting data, and preparing working breakdowns for tax returns. It also helps verify whether all certificates have been posted, whether they relate to the correct organization and contract, and which VAT rate is specified in the documents.
2. Where to Find It
Path in the interface:
“Sales” section → “Reports” block → “Information on Work Completion Certificates”.
The command name and report location may depend on the user’s permissions and interface settings. If the command is available, the report opens in a separate form with parameters and a “Generate” button.
3. How to Complete It (Report Settings)
Before generating the report, specify the parameters used to select documents. For monthly reconciliation, selecting the period and organization is usually sufficient; to verify settlements with a particular buyer, also specify the counterparty and contract.
Field / setting | Purpose | What happens if configured incorrectly |
|---|---|---|
Period | Restricts the selection of certificates by document date. | If the period is too broad, the report will include documents from other months. If it is too narrow, some required certificates will not be shown. |
Organization | Selects documents for a particular LLP or IE. This parameter is especially important for a database used to maintain the accounting records of several organizations. | Without this filter, data from different organizations may appear in the same selection, making the totals unsuitable for reconciliation for an individual taxpayer. |
Counterparty | Restricts the report to documents for a particular buyer. | If the field is left blank, the report will show certificates for all counterparties that meet the other conditions. |
Contract | Separates transactions when several contracts have been concluded with the same counterparty. | Without this filter, amounts under different contracts may be combined, so the total will not match the reconciliation for a particular contract. |
VAT rate | Helps select documents by the rate specified in them and find certificates prepared using the rate applicable before 2026. | If the wrong rate is selected, the required documents will not be included in the result. |
Grouping by counterparty, contract, or organization | Determines the structure of rows and subtotals. | Without a suitable grouping, the report will be presented as a flat list that is more difficult to compare with the counterparty’s data. |
Procedure:
Specify the period for which the reconciliation is performed.
Select the organization if the information database contains accounting records for several LLPs or IEs.
When reconciling with a buyer, add a filter by counterparty.
If several contracts have been concluded with the buyer, specify the required contract.
To find documents with an incorrect rate, add a filter by VAT rate.
Configure the groupings and required columns.
Click “Generate”.
After generating the report, check not only the grand total but also the rows for individual documents. If the amount differs from the counterparty’s reconciliation data, compare the date, certificate number, contract, amount excluding VAT, rate, and VAT amount in sequence.
Frequently used settings can be saved using the “More” → “Save Report Variant” command. In the following month, simply select the saved variant and change the period.
4. Worked Example with Accounting Entries
Scenario. Lakomka LLP, which is registered for VAT, provided two services to Client LLP under Contract No. 7 in September 2026:
Certificate No. 101 dated 05.09.2026 — consulting services amounting to 500 000 ₸ excluding VAT.
Certificate No. 102 dated 20.09.2026 — marketing services amounting to 250 000 ₸ excluding VAT.
The current VAT rate of 16 % is applied in the sales documents. Accounting entries relate to the source documents and depend on the accounting settings, service item, and selected accounts. The amounts from these documents are used for reconciliation in the report under consideration.
Calculation for Certificate No. 101:
Amount excluding VAT: 500 000 ₸.
VAT at 16 %: 500 000 × 16 % = 80 000 ₸.
Total payable: 500 000 + 80 000 = 580 000 ₸.
Calculation for Certificate No. 102:
Amount excluding VAT: 250 000 ₸.
VAT at 16 %: 250 000 × 16 % = 40 000 ₸.
Total payable: 250 000 + 40 000 = 290 000 ₸.
What the report shows after setting the “Counterparty = Client LLP” filter and the period from 01.09.2026 to 30.09.2026:
Certificate | Date | Amount excluding VAT, ₸ | VAT at 16 %, ₸ | Total, ₸ |
|---|---|---|---|---|
No. 101 | 05.09.2026 | 500 000 | 80 000 | 580 000 |
No. 102 | 20.09.2026 | 250 000 | 40 000 | 290 000 |
Total | 750 000 | 120 000 | 870 000 |
The counterparty provided reconciliation data amounting to 870 000 ₸. The report total matches: the cost of services excluding VAT is 750 000 ₸, VAT is 120 000 ₸, and the total amount is 870 000 ₸.
If the accounting records showed 840 000 ₸ under this contract, the accountant would need to compare each row. The difference of 30 000 ₸ corresponds to a deviation in the VAT calculation for the two certificates: 20 000 ₸ for Certificate No. 101 and 10 000 ₸ for Certificate No. 102. After correcting the rate and reposting the documents, the total will be 870 000 ₸.
5. What Is Generated When Working with the Report
After clicking the “Generate” button, the user receives a tabular breakdown of documents matching the specified conditions. It may include rows for certificates, counterparty and contract details, tax amounts, and totals for the selected groupings.
The results can conveniently be reviewed as follows:
first compare the grand total with the counterparty’s data or the working breakdown;
then check the subtotals by contract;
if there is a discrepancy, proceed to the rows for individual certificates;
open the source document and compare its date, amount, VAT rate, and posting status;
after correcting the document, regenerate the report using the same filters.
An E-invoice is issued in the designated workspace or on the basis of the corresponding sales document. The presence of a certificate in the report under consideration does not in itself mean that the related E-invoice has already been issued or sent. Therefore, when reconciling VAT, separately compare the certificates with the data in the E-invoicing Information System.
The report result can be used as an internal register: display it on screen, print it, or save it in an available format for subsequent analysis and coordination with the counterparty.
6. Printed Forms
To provide a list of certificates for reconciliation, print the generated table or save it to a file. The available commands depend on the platform interface and the user’s permissions.
Print — outputs the register with the columns and groupings displayed on screen.
Save As… — allows you to save the tabular document, including in .xlsx, .pdf, or .mxl format, if available in the installed platform version.
Report Settings — allow you to change the columns, filters, sorting, groupings, and display of totals.
Before sending the file to the counterparty, verify that it contains only the organization, counterparty, contract, and period relevant to the reconciliation. If a saved report variant is used, make sure the period has been updated.
The printed form of a particular certificate is obtained from the source document. The report is intended to display a list of certificates and total amounts, so it does not replace a copy of the primary document.
8. Common Errors
The wrong organization is selected. In a multi-company database, the report may contain documents for another LLP or IE. Set a filter for the required organization and regenerate the report.
The report total does not match the working VAT breakdown. Check the period, organization, document posting status, and rates in the certificates. For 2026 transactions under the standard taxation procedure, the current rate of 16 % is used in the example. Documents from previous periods should be assessed based on the turnover date and the rules applicable to them.
A recently created certificate is not included in the report. Compare the certificate date with the report period and check the organization, counterparty, contract, and other filters. After posting or correcting the document, refresh the report using the “Generate” button.
Certificates under several contracts are shown. This occurs when a counterparty is selected but no contract filter is set. Add the required contract or group the rows by contract to see separate totals.
The discrepancy with the counterparty is several tiyn. Compare the rounding of the VAT amount in each document row and the total for the certificate. To identify the cause, reconcile the line-by-line amounts rather than only the grand total.
After the certificate was corrected, the report still shows the previous data. Make sure the changes have been saved, the document has been posted, and the report has been regenerated. Also check whether a saved variant with additional filters is open.
The VAT column shows a zero value. Open the relevant certificate and check the transaction type, VAT rate, and completion of the tabular section. A zero value must correspond to the document details and the nature of the recorded transaction.
9. FAQ
1. What is the “Information on Work Completion Certificates” report used for?
It collects certificates for the selected period in one table and helps reconcile documents, counterparties, contracts, amounts excluding VAT, tax, and grand totals. If a discrepancy is found, the relevant source document is opened from the report.
2. Why does a 2026 certificate specify a VAT rate that is not current?
This may be caused by copying an old document, transferring data, or a saved row setting. Find such certificates using a rate filter, open each document, and bring its details into line with the transaction. The rate of 16 % is used for the 2026 example provided in the article.
3. How can I quickly reconcile one contract with a buyer?
Specify the period, organization, counterparty, and contract, then click “Generate”. First compare the grand total, followed by the amounts excluding VAT and the VAT for each certificate.
4. Why is the report empty even though certificates have been entered?
Check the document dates, selected period, organization, counterparty, contract, and additional filters. After changing the parameters, regenerate the report. Also check the posting status of the required certificates.
5. Can the report be exported for a counterparty?
Yes. The generated table can be printed or saved in an available format, such as .xlsx or .pdf. Before sending it, check the columns and make sure it contains no data relating to other counterparties.
6. How can I find a certificate with an incorrect tax rate?
Add a filter for a rate that differs from the current rate for the 2026 transactions under consideration. Then open the documents found and check the turnover date and VAT details. After making corrections, post the documents and regenerate the report.
7. Why might the report total differ from Form 300.00?
The report is a selection of certificates based on specified parameters, whereas the tax form is prepared using data for the relevant tax period and includes the transactions prescribed for it. For comparison, use the same period and organization, then analyze the breakdowns by document and transaction type.
8. Can the settings be saved for monthly reconciliation?
Yes. Use the “More” → “Save Report Variant” command. The next time you generate the report, select the saved variant, change the period, and check that the previous counterparty and contract filters are still appropriate.
9. Why does one certificate show an amount excluding VAT while its VAT amount is zero?
Open the certificate and compare the VAT rate, transaction type, and completion of the tabular section. The report displays the document data, so the reason is determined from the details of the relevant certificate.
10. What should I do if the report amount matches but one certificate number is missing?
Do not limit the check to the grand total. Compare the registers row by row using the document number and date. The same grand total may result when one certificate is omitted while another document for the same amount is incorrectly included.