{"id":157225,"date":"2026-11-06T16:33:31","date_gmt":"2026-11-06T16:33:31","guid":{"rendered":"https:\/\/docs.daftra.com\/?post_type=tutorial&#038;p=157225"},"modified":"2026-11-08T09:32:16","modified_gmt":"2026-11-08T09:32:16","slug":"reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/","title":{"rendered":"Reasons the Inventory Ledger Account Doesn\u2019t Match the Inventory Value Report"},"content":{"rendered":"<div dir=\"ltr\" lang=\"en\">\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">You may find that the <strong style=\"color: #111827;\">Inventory<\/strong> account balance in the ledger doesn&#8217;t equal the total of the <strong style=\"color: #111827;\">Inventory Value<\/strong> report. This is usually because the two aren&#8217;t calculated the same way: the report multiplies the current quantities by the current average cost, while the ledger is the sum of the journal entries actually recorded at their values at the time of each transaction. This guide explains how each one is calculated, how to compare them correctly, and then every cause of a mismatch and how to check and fix it.<\/p>\n<div style=\"background: #f6f8fb; border: 1px solid #e5e7eb; border-radius: 8px; padding: 12px 16px; margin: 0 0 20px; font-size: 15px; line-height: 1.8;\">\n<div style=\"display: flex; gap: 8px; padding: 4px 0;\"><span style=\"min-width: 120px; color: #6b7280;\">Inventory value report<\/span><a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/reports\/list\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Reports<\/strong><\/a> \u2192 <strong style=\"color: #111827;\">Store Reports<\/strong> \u2192 <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/products\/worthsheet\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Inventory Value<\/strong><\/a>.<\/div>\n<div style=\"display: flex; gap: 8px; padding: 4px 0;\"><span style=\"min-width: 120px; color: #6b7280;\">Inventory account<\/span><strong style=\"color: #111827;\">Chart of Accounts<\/strong> \u2192 the <strong style=\"color: #111827;\">Inventory<\/strong> account (the main account that the warehouse accounts branch from) \u2192 <strong style=\"color: #111827;\">Account Ledger<\/strong>.<\/div>\n<\/div>\n<div style=\"border: 1px solid #e5e7eb; border-radius: 8px; padding: 12px 16px; margin: 0 0 20px;\">\n<p style=\"margin: 0 0 6px; font-weight: bold; color: #111827;\">Contents<\/p>\n<ol style=\"margin: 0; padding-left: 22px;\">\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#how\"><strong style=\"color: #1a56db;\">How the report and the ledger are calculated<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#compare\"><strong style=\"color: #1a56db;\">Compare correctly first<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#compare-reasons\"><strong style=\"color: #1a56db;\">Causes related to how you compare<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#one-side\"><strong style=\"color: #1a56db;\">Transactions that affect only one side<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#cost\"><strong style=\"color: #1a56db;\">Cost differences<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#summary\"><strong style=\"color: #1a56db;\">Summary table: cause, how to check, and fix<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#faq\"><strong style=\"color: #1a56db;\">FAQs<\/strong><\/a><\/li>\n<\/ol>\n<\/div>\n<h2 id=\"how\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">How the report and the ledger are calculated<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\"><\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Inventory value report<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Inventory account in the ledger<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Quantity<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The sum of <strong style=\"color: #111827;\">processed<\/strong> stock transactions only for each product in the selected warehouses.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Doesn&#8217;t deal with quantities; it only adds up journal entry amounts.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Value<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Quantity \u00d7 the product&#8217;s <strong style=\"color: #111827;\">current average buy price<\/strong> (or the <strong style=\"color: #111827;\">Buy Price<\/strong> if you choose it, or if the average is zero).<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Total debit minus credit of the journal entries recorded at the value of each transaction when it happened.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Date<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The date changes the quantities only; the price is always today&#8217;s average.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The balance on a given date = the journal entries up to that date at their historical values.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Scope<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Products whose stock is tracked and whose status is Active or Suspended, in active or suspended warehouses you have permission to view, and in the current branch.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">All journal entries on the account, whether automatic or manual, and for any product.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div style=\"display: flex; gap: 10px; background: #f6f8fb; border-left: 4px solid #1a56db; border-radius: 6px; padding: 14px 16px; margin: 0 0 18px;\">\n<p><span style=\"flex: 0 0 auto; font-size: 18px; line-height: 1.6;\">\ud83d\udec8<\/span><\/p>\n<p style=\"margin: 0; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Note:<\/strong> Each warehouse has its own sub-account under the <strong style=\"color: #111827;\">Inventory<\/strong> account in the chart of accounts. So compare the report with the main <strong style=\"color: #111827;\">Inventory<\/strong> account (or with the total of the warehouse accounts), not with a single warehouse&#8217;s account.<\/p>\n<\/div>\n<h2 id=\"compare\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Compare correctly first<\/h2>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Many differences disappear as soon as you set up the comparison correctly. Before looking into the causes:<\/p>\n<ol style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Open the <strong style=\"color: #111827;\">Inventory Value<\/strong> report and leave <strong style=\"color: #111827;\">Warehouse<\/strong>, <strong style=\"color: #111827;\">Category<\/strong>, <strong style=\"color: #111827;\">Brand<\/strong>, and <strong style=\"color: #111827;\">Supplier<\/strong> on all.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">In <strong style=\"color: #111827;\">Calculate Using<\/strong>, choose <strong style=\"color: #111827;\">Average Buy Price<\/strong>, not <strong style=\"color: #111827;\">Buy Price<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Leave the start of the <strong style=\"color: #111827;\">Date Range<\/strong> empty, and set only its end if you want a balance on a past date, or leave both empty to compare with the current balance.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Click <strong style=\"color: #111827;\">Generate Sheet<\/strong>, and take the total of the <strong style=\"color: #111827;\">Total Buy Price<\/strong> column; this is the inventory value.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">View the balance of the main <strong style=\"color: #111827;\">Inventory<\/strong> account in the ledger up to the same date, without a branch or cost center filter that differs from the report.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Run the comparison as the owner, or as a user with permission to view all warehouses.<\/li>\n<\/ol>\n<div style=\"display: flex; gap: 10px; background: #f6f8fb; border-left: 4px solid #1a56db; border-radius: 6px; padding: 14px 16px; margin: 0 0 18px;\">\n<p><span style=\"flex: 0 0 auto; font-size: 18px; line-height: 1.6;\">\ud83d\udec8<\/span><\/p>\n<p style=\"margin: 0; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Warning:<\/strong> A comparison on a past date usually won&#8217;t match even if all the data is correct, because the report prices that date&#8217;s quantities at the current average cost, while the ledger keeps the cost at that time. The most accurate comparison is with the current balance.<\/p>\n<\/div>\n<h2 id=\"compare-reasons\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Causes related to how you compare<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">1. Different dates<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Comparing the ledger on one date with the report on another date.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">If you set a start date in the report, it shows the <strong style=\"color: #111827;\">net movement for the period<\/strong> only, not the balance at its end, so it can&#8217;t be compared with the account balance.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The report prices any date at the current average cost, as in the previous warning.<\/li>\n<\/ul>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">2. Filters and the pricing basis<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The report is filtered by a warehouse, category, brand, or supplier, and the ledger isn&#8217;t (or the other way around). The category filter includes the selected category and its direct subcategories only.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The report is calculated using <strong style=\"color: #111827;\">Buy Price<\/strong> instead of <strong style=\"color: #111827;\">Average Buy Price<\/strong>. A product with a zero average is priced in the report at the buy price even when the average is selected.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Comparing the report with a single warehouse&#8217;s account instead of the main <strong style=\"color: #111827;\">Inventory<\/strong> account.<\/li>\n<\/ul>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">3. Warehouses and branches the report doesn&#8217;t include<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Inactive<\/strong> warehouses don&#8217;t appear in the report, while their account balance stays in the ledger.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">An employee sees in the report only the warehouses they have permission to view. And anyone who has only the <strong style=\"color: #111827;\">View His Own (Created) Products<\/strong> permission sees only their own products.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">When branches are enabled, the report shows only the products of the current branch and the branches shared with it.<\/li>\n<\/ul>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">4. Warehouse account routing<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">From <strong style=\"color: #111827;\">Accounting Settings<\/strong> \u2192 <strong style=\"color: #111827;\">Accounts Routing<\/strong> \u2192 <strong style=\"color: #111827;\">Inventory<\/strong>, you can route each warehouse to a specific account. If a warehouse is routed to an account outside the <strong style=\"color: #111827;\">Inventory<\/strong> tree, its value appears in the report but isn&#8217;t included in the account you&#8217;re comparing with. Routing here is <strong style=\"color: #111827;\">at the warehouse level only<\/strong>; account routing at the product level is for the sales and cost of sales accounts, and doesn&#8217;t change the inventory account.<\/p>\n<h2 id=\"one-side\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Transactions that affect only one side<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">5. Manual journal entries on the inventory account<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Any manual journal entry on the inventory account or the warehouse accounts changes the ledger balance, but it doesn&#8217;t change the products&#8217; quantities or their value in the report. To actually adjust the inventory, use a <strong style=\"color: #111827;\">Manual Stock Adjustment<\/strong> or a stocktaking sheet instead of a manual journal entry.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">6. Opening balance<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The opening quantity you enter in the <strong style=\"color: #111827;\">Quantity<\/strong> field in the stock section when adding a product is recorded as a stock transaction at the purchase price, with an automatic journal entry: debit the warehouse account, credit <strong style=\"color: #111827;\">Other Credit Balances<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">If you also recorded a manual opening journal entry for the same inventory, the value is duplicated in the ledger. And if you recorded only the manual journal entry without opening quantities for the products, the value appears in the ledger and doesn&#8217;t appear in the report.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">If the opening quantity was added for a product whose <strong style=\"color: #111827;\">Purchase Price<\/strong> is empty, the quantity enters the report without any journal entry in the ledger.<\/li>\n<\/ul>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">7. Automatic journal entries stopped or accounts cancelled<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">When <strong style=\"color: #111827;\">Disable Automatic Journal Entries for Invoices<\/strong> is enabled, the cost of sales journal entry isn&#8217;t created, so the product leaves the inventory in the report without being deducted from the inventory account.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">If the account routing for <strong style=\"color: #111827;\">Purchases<\/strong> or <strong style=\"color: #111827;\">Purchase Returns<\/strong> is set to cancel, the goods enter the inventory and the purchase invoice journal entry isn&#8217;t created on the inventory account.<\/li>\n<\/ul>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">8. Stock requisitions and purchase invoices that aren&#8217;t received<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">When <strong style=\"color: #111827;\">Requisitions for Purchase Invoices<\/strong> is enabled, or if the purchase invoice isn&#8217;t <strong style=\"color: #111827;\">Received<\/strong>, the invoice journal entry is on the <strong style=\"color: #111827;\">Purchases<\/strong> account, not the inventory. The amount moves to the inventory account only when the requisition is approved.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">When <strong style=\"color: #111827;\">Requisitions for Sales Invoices<\/strong> is enabled, the revenue is recorded on the invoice date, while the cost of sales journal entry and the deduction from inventory are recorded when the requisition is approved, on the requisition date.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">A requisition <strong style=\"color: #111827;\">Under Review<\/strong> doesn&#8217;t affect quantities or journal entries. But if you compare on a date between the invoice date and the requisition approval date, or if the requisition value differs from the invoice value, the difference appears between the inventory and purchases.<\/li>\n<\/ul>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">9. Inactive products or products whose stock isn&#8217;t tracked<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">A product whose status is <strong style=\"color: #111827;\">Inactive<\/strong> doesn&#8217;t appear in the report, while its journal entries stay in the ledger. (A <strong style=\"color: #111827;\">Suspended<\/strong> product appears in the report.)<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">A product whose <strong style=\"color: #111827;\">Track Stock<\/strong> was turned off is excluded from the report entirely, even though its previous transactions have journal entries in the ledger.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">You can&#8217;t delete a product that has stock transactions; the system asks you to make it inactive, so it falls under the first case.<\/li>\n<\/ul>\n<h2 id=\"cost\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Cost differences<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">10. Back-dated transactions<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Adding or editing a purchase invoice or a stock transaction with a past date recalculates the average cost from that date for all following transactions, and updates the related cost of sales, requisition, and transfer journal entries. But a difference remains in the following cases:<\/p>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Closed periods:<\/strong> The cost journal entries of invoices dated within a closed period aren&#8217;t updated, so they stay at the old cost while the average changes in the report.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Manual stock adjustment (outbound):<\/strong> When the average changes, the cost of the manual outbound transaction is updated, but its journal entry stays at the value it was first recorded with.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Background recalculation:<\/strong> If the transaction date is more than 3 days old, the calculations are redone in the background, and temporary differences may appear until they finish. Compare again a little later.<\/li>\n<\/ul>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">11. Negative balance<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">When selling with a negative balance, the cost is calculated at the last available average (or at the purchase price if there&#8217;s no average). When purchasing after that, the average becomes the new purchase price without repricing the sales made while the balance was negative.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">In the report, the negative quantity is multiplied by the average, so a negative value appears and is deducted from the total.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The fix: record purchase invoices or additions with a date before the sale so the balance doesn&#8217;t become negative, or choose <strong style=\"color: #111827;\">Disable Negative Inventory For All Items<\/strong> under <strong style=\"color: #111827;\">Negative Inventory<\/strong> in the inventory settings so it doesn&#8217;t happen again.<\/li>\n<\/ul>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">12. Foreign currencies and rounding<\/h3>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The average cost is calculated at the exchange rate on the date the goods are received, while the journal entry is converted at the exchange rate on the journal entry date; the difference between them causes a difference in purchase invoices in a foreign currency.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The report shows each line rounded to two decimal places but adds up the original values, and journal entries are rounded to four decimal places; this causes only very small differences.<\/li>\n<\/ul>\n<div style=\"background: #f3faf6; border-left: 4px solid #0e9f6e; border-radius: 6px; padding: 14px 16px; margin: 0 0 18px;\">\n<p style=\"margin: 0 0 6px; color: #111827; font-weight: bold;\">Example<\/p>\n<div style=\"line-height: 1.9; font-size: 16px; color: #1f2430;\">You bought 10 pieces at 100 in January, and sold 5 in February, so a cost journal entry of 500 was recorded. Then in March you added a purchase invoice dated January for 10 pieces at 130, so the average became 115. If February is a closed period, the cost journal entry stays 500 and the ledger balance becomes 1300 + 1000 \u2212 500 = 1800, while the report shows 15 \u00d7 115 = 1725. The difference of 75 is the cost difference of the five pieces sold (5 \u00d7 15).<\/div>\n<\/div>\n<h2 id=\"summary\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Summary table: cause, how to check, and fix<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Cause<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">How to check<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Fix<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Different date or filters<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Check the start of the date range, the filters, and the pricing basis in the report.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Follow the steps in <a style=\"color: #1a56db;\" href=\"#compare\">Compare correctly first<\/a>.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Inactive warehouses or no permission<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Compare the warehouses in the report with the warehouse accounts under <strong style=\"color: #111827;\">Inventory<\/strong>.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Activate the warehouse temporarily, or compare as the owner.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Warehouse routed to another account<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Accounts Routing<\/strong> \u2192 <strong style=\"color: #111827;\">Inventory<\/strong>.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Add the routed account to the comparison, or correct the routing.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Manual journal entries<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">In the account ledger, look for the non-automatic journal entries.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Delete the journal entry and replace it with a manual stock adjustment or a stocktaking sheet.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Duplicated or missing opening balance<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Look for a manual opening journal entry on the inventory, and for products with an opening quantity and an empty purchase price.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Use one method: the products&#8217; opening quantities, and delete the duplicated manual journal entry.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Automatic journal entries stopped<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Check <strong style=\"color: #111827;\">Disable Automatic Journal Entries for Invoices<\/strong> and the account routing for purchases and purchase returns.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Re-enable the automatic journal entries and correct the routing.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Stock requisitions<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Look for requisitions <strong style=\"color: #111827;\">Under Review<\/strong>, and check the <strong style=\"color: #111827;\">Purchases<\/strong> account balance.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Approve the pending requisitions, and compare after processing them.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Inactive or untracked products<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Filter the products list by the <strong style=\"color: #111827;\">Inactive<\/strong> status, and check the products whose stock tracking was turned off.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Bring their balance to zero with a manual stock adjustment before deactivating them or turning off their tracking.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Back-dated transactions<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Check the purchase invoices added or edited with a past date, and the closed periods.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Wait for the recalculation to finish, or open the closed period and edit the document so its journal entry is recreated, or record an adjustment journal entry.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Negative balance<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Look for negative quantities in the report.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Correct the purchase dates, or add the missing quantities with a date before the sale.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Currencies and rounding<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The difference is small and related to invoices in a foreign currency.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Record an adjustment journal entry for the difference if needed.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"faq\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">FAQs<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Why does the report total for a past date change even though I didn&#8217;t add transactions on that date?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Because the report always prices quantities at the current average cost, so any new purchase that changes the average also changes the value of past dates.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Do transfers between warehouses cause a difference?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No, if you compare with the main <strong style=\"color: #111827;\">Inventory<\/strong> account; a transfer deducts from one warehouse&#8217;s account and adds to another at the same value. The difference appears only if you compare with a single warehouse&#8217;s account, or if one of the two warehouses is routed to an account outside the inventory.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Does a manual stock adjustment affect the inventory account?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Yes; an addition is recorded as a debit to the warehouse account and a credit to <strong style=\"color: #111827;\">Other Credit Balances<\/strong>, and an outbound adjustment as a credit to the warehouse account and a debit to <strong style=\"color: #111827;\">Other Debit Balances<\/strong>, unless you choose the <strong style=\"color: #111827;\">Sub Account<\/strong> in the transaction form.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Do drafts affect either side?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No. Draft sales and purchase invoices don&#8217;t create journal entries, and the report counts processed stock transactions only.<\/p>\n<\/div>\n","protected":false},"author":39,"featured_media":0,"template":"","categories":[2182,2177,2093,7849],"tags":[4255,29150,23760,29147,29148,29151,29146,29149,22693,19237],"class_list":["post-157225","tutorial","type-tutorial","status-publish","hentry","category-requisitions","category-inventory","category-reports","category-store-reports","tag-accounts-routing","tag-average-buy-price","tag-closed-periods","tag-inventory-account","tag-inventory-ledger","tag-inventory-reconciliation","tag-inventory-value-report","tag-ledger-and-inventory-mismatch","tag-negative-inventory","tag-stock-requisitions-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Reasons the Inventory Ledger Account Doesn\u2019t Match the Inventory Value Report - Daftra Knowledge Base<\/title>\n<meta name=\"description\" content=\"Learn why the inventory account balance in the ledger can differ from the inventory value report, how to compare them correctly, and how to fix each cause.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reasons the Inventory Ledger Account Doesn\u2019t Match the Inventory Value Report - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"Learn why the inventory account balance in the ledger can differ from the inventory value report, how to compare them correctly, and how to fix each cause.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-08T09:32:16+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.daftra.com\/#organization\",\"name\":\"Daftra\",\"url\":\"https:\/\/docs.daftra.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"caption\":\"Daftra\"},\"image\":{\"@id\":\"https:\/\/docs.daftra.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/#website\",\"url\":\"https:\/\/docs.daftra.com\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"publisher\":{\"@id\":\"https:\/\/docs.daftra.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/\",\"name\":\"Reasons the Inventory Ledger Account Doesn\\u2019t Match the Inventory Value Report - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"datePublished\":\"2026-11-06T16:33:31+00:00\",\"dateModified\":\"2026-11-08T09:32:16+00:00\",\"description\":\"Learn why the inventory account balance in the ledger can differ from the inventory value report, how to compare them correctly, and how to fix each cause.\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reasons the Inventory Ledger Account Doesn\\u2019t Match the Inventory Value Report\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reasons the Inventory Ledger Account Doesn\u2019t Match the Inventory Value Report - Daftra Knowledge Base","description":"Learn why the inventory account balance in the ledger can differ from the inventory value report, how to compare them correctly, and how to fix each cause.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/","og_locale":"en_US","og_type":"article","og_title":"Reasons the Inventory Ledger Account Doesn\u2019t Match the Inventory Value Report - Daftra Knowledge Base","og_description":"Learn why the inventory account balance in the ledger can differ from the inventory value report, how to compare them correctly, and how to fix each cause.","og_url":"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-11-08T09:32:16+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/docs.daftra.com\/#organization","name":"Daftra","url":"https:\/\/docs.daftra.com\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/#logo","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","caption":"Daftra"},"image":{"@id":"https:\/\/docs.daftra.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/#website","url":"https:\/\/docs.daftra.com\/","name":"Daftra Knowledge Base","description":"Daftra","publisher":{"@id":"https:\/\/docs.daftra.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/#webpage","url":"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/","name":"Reasons the Inventory Ledger Account Doesn\u2019t Match the Inventory Value Report - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"datePublished":"2026-11-06T16:33:31+00:00","dateModified":"2026-11-08T09:32:16+00:00","description":"Learn why the inventory account balance in the ledger can differ from the inventory value report, how to compare them correctly, and how to fix each cause.","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/reasons-the-inventory-ledger-account-doesnt-match-the-inventory-value-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Reasons the Inventory Ledger Account Doesn\u2019t Match the Inventory Value Report"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/157225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/39"}],"version-history":[{"count":5,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/157225\/revisions"}],"predecessor-version":[{"id":157232,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/157225\/revisions\/157232"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=157225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=157225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=157225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}