{"id":158185,"date":"2026-10-26T07:39:55","date_gmt":"2026-10-26T07:39:55","guid":{"rendered":"https:\/\/docs.daftra.com\/tutorial\/adding-opening-inventory-balances\/"},"modified":"2026-11-11T14:47:03","modified_gmt":"2026-11-11T14:47:03","slug":"adding-opening-inventory-balances","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/","title":{"rendered":"Adding Opening Inventory Balances"},"content":{"rendered":"<div dir=\"ltr\" lang=\"en\">\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The opening balance for Inventory is the quantity of products physically in the warehouse when you start working on the system, or carried forward from a previous financial period. You record it using a <strong style=\"color: #111827;\">Manual Addition Requisition<\/strong> so that it affects both quantity and value.<\/p>\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> You need permission to add Requisitions, and the Inventory app must be enabled. You can set permissions from <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/roles\/index\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Roles<\/strong><\/a>.<\/p>\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;\">Table of Contents<\/p>\n<ol style=\"margin: 0; padding-left: 22px;\">\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#when\"><strong style=\"color: #1a56db;\">When should you record the opening balance?<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#steps\"><strong style=\"color: #1a56db;\">Steps to add the opening balance<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#fields\"><strong style=\"color: #1a56db;\">Field descriptions<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#paste\"><strong style=\"color: #1a56db;\">Copying items from a spreadsheet<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#rules\"><strong style=\"color: #1a56db;\">Rules and restrictions<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#errors\"><strong style=\"color: #1a56db;\">Error messages and solutions<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#impact\"><strong style=\"color: #1a56db;\">Impact on the system<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#alternatives\"><strong style=\"color: #1a56db;\">Alternatives<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#faq\"><strong style=\"color: #1a56db;\">Frequently asked questions<\/strong><\/a><\/li>\n<\/ol>\n<\/div>\n<h2 id=\"when\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">When should you record the opening balance?<\/h2>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Recording the opening balance is <strong style=\"color: #111827;\">optional<\/strong>. You can start right away by adding Purchase Invoices, Sales invoices, and other documents without recording it; a Purchase Invoice adds quantities to Inventory, and a Sales invoice deducts them.<\/p>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Record the opening balance if you had goods in the warehouse before you started using the system, so that:<\/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;\">Product quantities in the system match the warehouse.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The cost of goods sold is calculated correctly.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">You can sell these goods if the <strong style=\"color: #111827;\">Negative Inventory<\/strong> setting is set to <strong style=\"color: #111827;\">Stop transactions when the quantity runs out for all products<\/strong>.<\/li>\n<\/ul>\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> Do not record the opening balance for Inventory with a Journal Entry; a Journal Entry affects only the account balance and does not add quantities to products.<\/p>\n<\/div>\n<h2 id=\"steps\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Steps to add the opening balance<\/h2>\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;\">From the main menu, click <strong style=\"color: #111827;\">Inventory<\/strong>, then <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/requisitions\/index\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Manage Requisitions<\/strong><\/a>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Click <strong style=\"color: #111827;\">Add<\/strong>, or click the arrow next to it and choose <strong style=\"color: #111827;\">Manual Addition<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Under <strong style=\"color: #111827;\">Requisition Details<\/strong>, select the <strong style=\"color: #111827;\">Date<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Under <strong style=\"color: #111827;\">Warehouse Details<\/strong>, choose the <strong style=\"color: #111827;\">Warehouse<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Under <strong style=\"color: #111827;\">Other Information<\/strong>, choose the <strong style=\"color: #111827;\">Sub-account<\/strong>, and add any <strong style=\"color: #111827;\">Notes<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Under <strong style=\"color: #111827;\">Items<\/strong>, add the products, and set the <strong style=\"color: #111827;\">Unit Price<\/strong> and <strong style=\"color: #111827;\">Quantity<\/strong> for each product. To add a large number of products, use <a style=\"color: #1a56db;\" href=\"#paste\"><strong style=\"color: #1a56db;\">Copy from spreadsheet<\/strong><\/a>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Click <strong style=\"color: #111827;\">Confirm<\/strong>.<\/li>\n<\/ol>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The manual addition Requisition is saved with the status <strong style=\"color: #111827;\">Approved<\/strong> right away, and the quantities are added to the warehouse.<\/p>\n<h2 id=\"fields\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Field descriptions<\/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;\">Field<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Description<\/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;\">Date<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The date the balance is added. The journal entry is recorded with this date. Select the date you started using the system or the start of the fiscal period.<\/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<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The warehouse the quantities are added to. This field appears only when you have more than one warehouse.<\/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;\">Sub Account<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The account that offsets the inventory value in the journal entry. The default is <strong style=\"color: #111827;\">Other Creditors<\/strong>. This field appears when Accounting is enabled.<\/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;\">Notes<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Any notes about the requisition.<\/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;\">Unit Price<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The cost of one unit of the product. It is used to calculate the average cost.<\/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;\">Quantity<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The quantity of the product being added.<\/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 Balance Before<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The quantity of the product in the warehouse before the requisition. The system displays it automatically.<\/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 Balance After<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The quantity of the product in the warehouse after the requisition. The system displays it automatically.<\/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;\">Total<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Unit Price \u00d7 Quantity.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"paste\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Copy Items from a Spreadsheet<\/h2>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">If your product data is in an Excel file, you can copy and paste it all at once instead of adding each product manually.<\/p>\n<div style=\"display: flex; gap: 10px; background: #f6f8fb; border-right: 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;\">Before you start:<\/strong> Make sure the <strong style=\"color: #111827;\">Item Name\/Code<\/strong> in your Excel file matches the product name or code in the system.<\/p>\n<\/div>\n<ol style=\"margin: 0 0 16px; padding-right: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">On the manual add requisition page, click the arrow next to <strong style=\"color: #111827;\">Add<\/strong> below the items table.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Select <strong style=\"color: #111827;\">Copy from Spreadsheet<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Copy the <strong style=\"color: #111827;\">Item Name\/Code<\/strong> column from your Excel file and paste it into the first cell of the same column in the table. All the values in the column are pasted automatically.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Repeat the same step for the <strong style=\"color: #111827;\">Quantity<\/strong> and <strong style=\"color: #111827;\">Unit Price<\/strong> columns.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">To delete the items you added manually before the import, enable <strong style=\"color: #111827;\">Remove Old Records<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Click <strong style=\"color: #111827;\">Import<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Review the items on the requisition page, then click <strong style=\"color: #111827;\">Confirm<\/strong>.<\/li>\n<\/ol>\n<div style=\"display: flex; gap: 10px; background: #f6f8fb; border-right: 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> If any value doesn&#8217;t match, the data isn&#8217;t imported until you correct it.<\/p>\n<\/div>\n<h2 id=\"rules\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Rules and Restrictions<\/h2>\n<ul style=\"margin: 0 0 16px; padding-right: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The quantity and unit price must be positive numbers.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">You can add up to 500 items at a time from a spreadsheet.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The <strong style=\"color: #111827;\">Unit Price<\/strong> is used to calculate the product&#8217;s average cost, so enter the actual cost, not the selling price.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">You can&#8217;t add a requisition dated within a closed period.<\/li>\n<\/ul>\n<h2 id=\"errors\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Error Messages and Solutions<\/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;\">Message<\/th>\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;\">Solution<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The product code was not found in the system<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The product name or code in the spreadsheet does not exist in the system.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Correct the name or code to match the product in the system, or add the product first.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">You must enter valid positive numbers in Quantity<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The quantity is empty, negative, or not a number.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Enter a positive quantity.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">You must enter valid positive numbers in Price<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The unit price is empty, negative, or not a number.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Enter a positive unit price.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">You can add up to 500 items only<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">You pasted more than 500 items.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Split the items across more than one Requisition.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"impact\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Impact on the System<\/h2>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">A Journal Entry is created automatically when you save the Requisition. Example: adding 10 units at a price of 50 per unit:<\/p>\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;\">Account<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Debit<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Credit<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Warehouse account<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">500<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Other Payables (or the selected sub-account)<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">500<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top; background: #f6f8fb; font-weight: bold;\">Total<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top; background: #f6f8fb; font-weight: bold;\">500<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top; background: #f6f8fb; font-weight: bold;\">500<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul style=\"margin: 0 0 16px; padding-right: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Quantities:<\/strong> The quantity of each product increases in the selected warehouse.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Average cost:<\/strong> It is recalculated based on the <strong style=\"color: #111827;\">Unit Price<\/strong>.<\/li>\n<\/ul>\n<h2 id=\"alternatives\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Alternatives<\/h2>\n<ul style=\"margin: 0 0 16px; padding-right: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Quantity in Inventory<\/strong> when adding a new product: Use this to enter the opening quantity for a single product directly. The field appears for a new product that has no balance, and when Requisitions are not enabled for Sales and Purchase Invoices.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Purchase Invoice<\/strong>: Use this if you will record the goods as Purchases from a Supplier instead of an opening balance.<\/li>\n<\/ul>\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;\">Frequently Asked Questions<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Do I have to record an opening balance before adding Purchases and Sales?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No. Recording an opening balance is optional, and you can add Purchase Invoices, Sales, and other transactions directly. However, if the <strong style=\"color: #111827;\">Negative Stock<\/strong> setting is set to <strong style=\"color: #111827;\">Stop transactions when quantity runs out for all products<\/strong>, you will not be able to sell a product that has no balance. <a style=\"color: #1a56db;\" href=\"#when\"><strong style=\"color: #1a56db;\">Details<\/strong><\/a>.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Can I record the opening inventory balance with a Journal Entry?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">This is not recommended, because the entry affects only the account balance and does not add quantities to the products. Use <strong style=\"color: #111827;\">Manual Add<\/strong>.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Which date should I choose for the opening balance?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Use the date you started working on the system or the start of the financial period. It is best for this date to precede the date of any Sales of these products.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Which account is affected by the opening balance value?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The warehouse account is debited, and <strong style=\"color: #111827;\">Other Payables<\/strong> is credited by default. You can change it from <strong style=\"color: #111827;\">Sub Account<\/strong>.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Can I add the opening balance for a large number of products at once?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Yes, by using <strong style=\"color: #111827;\">Paste from Spreadsheet<\/strong>, with up to 500 items per requisition. <a style=\"color: #1a56db;\" href=\"#paste\"><strong style=\"color: #1a56db;\">Details<\/strong><\/a>.<\/p>\n<\/div>\n","protected":false},"author":39,"featured_media":0,"template":"","categories":[2182],"tags":[30250,5436,30252,29460,30251,4149,5296,30249,23362,30248,5297,30253],"class_list":["post-158185","tutorial","type-tutorial","status-publish","hentry","category-requisitions","tag-add-opening-quantities","tag-average-cost","tag-can-i-record-the-inventory-opening-balance-with-a-journal-entry","tag-copy-from-spreadsheet-en","tag-how-do-i-add-an-opening-balance-for-inventory","tag-inventory","tag-inventory-opening-balance","tag-manual-addition-requisition","tag-opening-balance-journal-entry","tag-opening-stock","tag-requisitions","tag-which-date-should-i-use-for-the-opening-balance"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Adding Opening Inventory Balances - Daftra Knowledge Base<\/title>\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\/adding-opening-inventory-balances\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adding Opening Inventory Balances - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"The opening balance for Inventory is the quantity of products physically in the warehouse when you start working on the system, or carried forward from a previous financial period. You record it using a Manual Addition Requisition so that it affects both quantity and value. \ud83d\udec8 Note: You need permission to add Requisitions, and the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-11T14:47:03+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=\"6 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\/adding-opening-inventory-balances\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/\",\"name\":\"Adding Opening Inventory Balances - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"datePublished\":\"2026-10-26T07:39:55+00:00\",\"dateModified\":\"2026-11-11T14:47:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding Opening Inventory Balances\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Adding Opening Inventory Balances - Daftra Knowledge Base","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\/adding-opening-inventory-balances\/","og_locale":"en_US","og_type":"article","og_title":"Adding Opening Inventory Balances - Daftra Knowledge Base","og_description":"The opening balance for Inventory is the quantity of products physically in the warehouse when you start working on the system, or carried forward from a previous financial period. You record it using a Manual Addition Requisition so that it affects both quantity and value. \ud83d\udec8 Note: You need permission to add Requisitions, and the [&hellip;]","og_url":"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-11-11T14:47:03+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 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\/adding-opening-inventory-balances\/#webpage","url":"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/","name":"Adding Opening Inventory Balances - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"datePublished":"2026-10-26T07:39:55+00:00","dateModified":"2026-11-11T14:47:03+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/adding-opening-inventory-balances\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Adding Opening Inventory Balances"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158185","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":3,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158185\/revisions"}],"predecessor-version":[{"id":158188,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158185\/revisions\/158188"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=158185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=158185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=158185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}