How to Set a Procurement Budget

Why a buying limit in a spreadsheet is late

Teams often keep a buying budget in a workbook that is updated after the purchase order exists. By then the commitment is already with the supplier. The sheet and the orders disagree because nobody added the requests that are still waiting for approval.

A single company total also hides a department that has already used its share. The opposite problem is a dozen sheets, one per site, that do not roll up.

A procurement budget is checked when the requisition is submitted and again when quotes are awarded. The most specific row wins. No matching row means unlimited. The check does not create an accounting journal.

Why this happens

• The budget is updated only after the order is sent.
• Pending requests are left out of the total.
• A department row and a company row are both applied.
• The buying budget is confused with an expense claim budget.

Biznsbook addresses this through annual, quarterly, or monthly budgets, optional department or cost center, warn or block on submit and award, pending requests plus linked orders in the Procurement module. The module creates a draft purchase order in Purchase. It does not receive stock and it does not post journals.

Buying problems rarely come from one large order. They come from requests that were approved in email, retyped, and then impossible to match. One requisition, with the decision and the draft order attached, removes that gap.

Step-by-step: Set a Procurement Budget

Written for buyers and approvers who need a request on record before a purchase order. The steps follow Procurement in Biznsbook.

1. Choose the company mode. In Procurement Settings, set the budget mode to Off, Warn, or Block. Off ignores budgets. Warn is the default: submit and award continue, and the screen says the budget is over. Block refuses submit.
2. Add a budget row. Procurement, then Budgets. Each row has a name, a fiscal year, a period of annual, quarterly, or monthly, an optional period number, and an amount.
3. Limit a row only when you mean to. An optional department or cost center applies that row to requisitions with the same ids. Leave both blank for a company-wide row.
4. Let the specific row win. A department and cost center beats a company-wide row. A month beats a quarter, which beats a year. No matching budget means unlimited.
5. Know what counts. Pending includes requisitions in pending approval, approved, and pending sourcing, excluding the one being checked. Actuals are linked purchase orders that are not cancelled, where the requisition dimensions match. Money is compared with a one-cent tolerance.
6. See the effect on submit. Warn stores a message on the requisition and continues. Block refuses submit.
7. See the effect on an award. Award checks the awarded prices. If the mode is Block and the buyer does not allow a partial award, nothing is created. If a partial award is allowed, supplier groups that would break the budget are skipped.

Review results after the first full monthly cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Inside Biznsbook, open Procurement and then Guide for the seven setup checks. This article explains the business process behind those screens.

Common mistakes to avoid

• Mistake 1: The budget is updated only after the order is sent. Repeating this each month usually shows up first in a purchase that skipped approval or no longer matches the request.
• Mistake 2: Pending requests are left out of the total. Repeating this each month usually shows up first in a purchase that skipped approval or no longer matches the request.
• Mistake 3: A department row and a company row are both applied. Repeating this each month usually shows up first in a purchase that skipped approval or no longer matches the request.
• Mistake 4: The buying budget is confused with an expense claim budget. Repeating this each month usually shows up first in a purchase that skipped approval or no longer matches the request.

Each of these shows up as an order that does not match the request, or a request nobody can find. Fix it on the requisition rather than with another spreadsheet tab.

Best practices that hold up as you scale

• Choose the company mode — In Procurement Settings, set the budget mode to Off, Warn, or Block.
• Add a budget row — Procurement, then Budgets.
• Limit a row only when you mean to — An optional department or cost center applies that row to requisitions with the same ids.
• Let the specific row win — A department and cost center beats a company-wide row.
• Know what counts — Pending includes requisitions in pending approval, approved, and pending sourcing, excluding the one being checked.

Keep the request, the approval, and the draft purchase order on the same requisition. Purchase still approves, receives, and bills the order.

How Biznsbook supports this workflow

annual, quarterly, or monthly budgets is part of Biznsbook Procurement. It stays on the requisition or the request for quote until a draft purchase order is created in Purchase. Procurement does not receive goods and does not post a journal.

optional department or cost center is part of Biznsbook Procurement. It stays on the requisition or the request for quote until a draft purchase order is created in Purchase. Procurement does not receive goods and does not post a journal.

warn or block on submit and award is part of Biznsbook Procurement. It stays on the requisition or the request for quote until a draft purchase order is created in Purchase. Procurement does not receive goods and does not post a journal.

pending requests plus linked orders is part of Biznsbook Procurement. It stays on the requisition or the request for quote until a draft purchase order is created in Purchase. Procurement does not receive goods and does not post a journal.

Access is permission-based. Procurement Manager covers requisitions, requests for quote, budgets, and settings. Buyer can create and submit requisitions and run requests for quote. Procurement Approver can view and approve assigned requisitions. Company Admin keeps full access. There is no separate reports screen in this release.

Suggested implementation timeline

1. Week 1: License Procurement with Purchase, save Settings once, and confirm the approval workflow. Then try annual, quarterly, or monthly budgets.
2. Week 2: Pilot with one buyer and one approver: raise a real requisition, approve it, and leave the purchase order in Draft until Purchase approval runs.
3. Week 3: Add a budget row or leave the mode on Warn, and send one request for quote if you compare suppliers.
4. Month 2: Assign Buyer, Procurement Approver, and Procurement Manager. Retire the request spreadsheet for new buys.
5. Ongoing: Monthly review using budgets are not encumbrance accounting.

Related guides

Start with raising a purchase requisition and approving a purchase requisition, then sending a request for quote.

The Procurement overview lists what this add-on includes. Procurement software vs spreadsheets is the decision page. Purchase orders, receipts, and bills stay in Purchase.

Industry: wholesale, manufacturing, retail.

A budget row is not a purchase order

Hitting Warn does not stop the buyer, and it does not create an order. Hitting Block stops submit, or skips a supplier group on a partial award. The purchase order still has to be created by conversion or by the award, and it still starts as Draft.

Metrics to track monthly

• Requisitions waiting for approval longer than the escalation hours
• Approved requisitions that still have no purchase order
• Requests for quote past their deadline
• Requisitions warned or blocked by a budget

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Spreadsheets and email vs Biznsbook Procurement

Compare a typical email-and-spreadsheet buying process with Biznsbook annual, quarterly, or monthly budgets and the related Procurement capabilities.

Budgets are not encumbrance accounting

The check is a buying limit on the requisition and on the award. It does not create a commitment journal, and it does not reserve a general-ledger balance. Purchase still posts receipts and bills through its own path. If you need a department on the requisition, enter the department id so it can match a budget row.

Write the rule into your buying policy so requesters, approvers, and buyers follow the same steps, and revisit it each quarter.

Frequently asked questions

How this differs by industry