Callback
  • From a market stall to a store

  • -

  • From a store to a retail chain

  • -

  • From retail to manufacturing

Why there is a discrepancy of a few kopecks in invoices and how to fix it

Volodymyr Vytyshchenko
Volodymyr Vytyshchenko

Trade automation expert at Torgsoft

The “cents” and rounding issue: what to do if the final amount in the program differs from the supplier invoice by 2–3 cents, causing reports not to match or import into accounting software to fail?

This material is intended for users and system administrators who have basic skills in working with the operating system, Windows services, and Microsoft SQL Server. All actions described are performed at your own risk: incorrect changes to settings, services, or the database may lead to data loss or program malfunction. Before making any changes, it is recommended to create an up-to-date database backup, check free disk space, and make sure there are no active users in the system. If you are not confident in the correctness of the actions or do not understand the consequences — you should contact technical support.

The issue of 2–3 cent discrepancies between Torgsoft and supplier invoices (and, as a result, the inability to import into accounting software) is a known systemic situation that users often encounter.

Why does the “cents issue” occur?

The main reason lies in the architectural difference between managerial and accounting records. Torgsoft was created specifically as a managerial accounting tool, not as a strict accounting system. Therefore, in the system architecture itself, product prices and line-item amounts during mathematical calculations (for example, when выделating VAT, calculating discounts, or allocating costs) are not strictly limited to two decimal places (cents).

When you try to export this data to accounting programs that require exact cent-level matching, a conflict arises: the import fails because of discrepancies in the final totals. Sometimes the issue also appears directly when receiving goods into stock, when Torgsoft rounds the invoice differently from the supplier’s accounting system.

What you can do right now: practical steps

You can minimize discrepancies with the correct settings inside Torgsoft:

1. Enable purchase price rounding 

Go to the menu Settings -> Parameters -> Documents tab. Find and enable the switch Round purchase price in the goods receipt invoice. If this setting is enabled, then for invoices where the parameter “Add VAT to the purchase price” is applied, the supplier price in calculations will be forcibly rounded to cents.

2. Adjust VAT calculation 

After program updates, the VAT calculation algorithm is sometimes calculated from a value with two decimal places, which may affect totals if the invoice contains low-cost items. Make sure you are using the latest version of the program, where the ability to change VAT calculation settings has been added.

3. Use “Advanced mode” for invoices 

If discrepancies occur while working in “Trade with Invoice Issuing” (TVR) mode, enable the extended settings (the Use advanced mode switch). When this parameter is enabled, the setting “Use rounding in Trade with Invoice Issuing” becomes available,  which allows you to use receipt rounding and product type rounding in TVR. Use the invoice price adjustment action for VAT printing.

4. Correctly allocate invoice costs 

When receiving goods into stock, after entering all additional costs, invoice discounts, or taxes, be sure to click the Recalculate prices in invoice button. This will force the program to recalculate supplier prices, additional cost, and calculate new selling prices for each unit of goods.

5. Rounding settings in “Product Type” 

Check the settings of the product type tree (Merchandising -> Product Type). In the “Price rounding” block, make sure the value you need is set (for example, “Round to cents”, so that the price is rounded strictly to 2 decimal places).

If after applying these settings some invoices still differ from the supplier’s data by a few cents, the only current solution is manual adjustment of the final amounts or discounts in the Torgsoft invoice before export, or manual correction of the imported document directly in the accounting software.


Програма обліку товару | Торгсофт



Facebook Instagram YouTube Twitter Google News Apple Podcast SounCloud

Add comment

Add comment
Thank you for your feedback! It will be published after being reviewed by a moderator.
Related articles