Cristian Iriart | Accountant, Cultivar
Public accountant (Argentina) · Formerly PwC
Last updated: November 6, 2026 · 6 min read
Key Takeaways
- Six business days give every task in the close its own day, and the example brand sends its borrowing base certificate a full week before the October 15 deadline.
- Logging every short payment with its deduction code on day 1 sets up the deduction match on day 4.
- In the example, counting $17,300 of unmatched deductions as eligible would overstate availability by $13,840, and the article shows the borrowing base math behind that gap.
- Adjusting the books to each partner’s month-end inventory report added $7,480 of shrinkage to September cost of goods sold in the example, and tagging short-dated stock in the same pass shows what the lender will set aside.
- Steady closes also help brands qualify for programs such as SBA’s 7(a) Working Capital Pilot, which offers lines of credit up to $5 million through July 31, 2027.
Last month at our example sparkling beverage brand, the 12th arrived with the borrowing base certificate due on the 15th. The 3PL’s inventory report sat unread in an inbox, and one distributor payment had landed short that morning, with a page of deduction codes attached. Your month-end close checklist can follow a fixed six-business-day calendar, with a clear task for every day.
I’m Cristian Iriart, an Accountant at Cultivar. I trained as a Contador Público Nacional, Argentina’s national public accountant qualification, at Universidad Nacional de Cuyo. I spent nearly four years as a tax senior at PwC Argentina.
Our illustrative brand sells $2,750,000 a year of canned sparkling beverages. Its co-packer makes the cans, and a 3PL stores them for the brand’s two distributors. The brand carries a $425,000 revolving line with a $318,000 balance on September 30. Its loan agreement asks for the borrowing base certificate by October 15 and monthly statements by October 30.
How Long Should a CPG Month-End Close Take?
Plan six business days for your CPG month-end close, finishing several business days before the earliest reporting deadline in your loan agreement.
The month-end close means finishing every reconciliation, accrual, inventory count, and adjustment for the month, so your P&L and balance sheet show what happened. Accrual accounting records revenue when it’s earned and expenses when they’re incurred. Cultivar’s CPG accounting services deliver accurate monthly closes and monthly P&L, balance sheet, and cash flow reports for food, beverage, and alcohol brands.
CPG bookkeeping adds four pieces to every close:
- Inventory that sits at a co-packer or 3PL, counted by your partners.
- Production batches that get billed after they’re made.
- Promotions that distributors deduct weeks or months later.
- Payments that arrive short, with deduction codes attached.
The borrowing base is the amount a lender will advance against your collateral. Lenders figure it by applying a percentage to each type of eligible collateral, such as receivables and inventory, and each percentage is an advance rate. I love a close calendar that gives every day one job, so the lender package is ready days early.
| Business day | Date | Close task | Number it produces |
|---|---|---|---|
| 1 | Thursday, October 1 | Cash and loan balances | Reconciled cash and the line balance |
| 2 | Friday, October 2 | Bills and accruals | Complete September costs |
| 3 | Monday, October 5 | Inventory | Counted inventory and shrinkage |
| 4 | Tuesday, October 6 | Deductions | Matched trade spend and flagged amounts |
| 5 | Wednesday, October 7 | Review and lock | Final September statements |
| 6 | Thursday, October 8 | Lender package | The borrowing base certificate |
Caption: Save this calendar next to your loan agreement and finish your close on business day 6, well ahead of your first deadline.
Steady closes also help you qualify for programs such as SBA’s 7(a) Working Capital Pilot. The SBA Working Capital Pilot eligibility rules limit the program to businesses with a history of 12 full months of operations before they apply. Eligible businesses can produce timely and accurate financial statements, accounts receivable and accounts payable agings, and inventory reports. SBA’s Federal Register notice says the pilot remains in effect through July 31, 2027, with lines of credit up to $5 million.
What Comes First on a Month-End Close Checklist?
Reconcile cash first, matching every bank account, credit card, and line of credit balance to its statement on day 1. Then enter the month’s bills and accruals on day 2.
What Happens on Day 1 of the Close?
Day 1 covers bank and card reconciliations and the line balance against the lender’s statement. It also covers cash application, which means matching each customer payment to the invoices it pays.
I recommend logging every short payment on day 1, with the distributor’s deduction code and the amount. That little log sets up the deduction match on day 4, and it saves you a second trip through the remittances.
What Gets Recorded on Day 2?
Vendor bills and accruals fill day 2, and Pedro’s post on using accruals to speed up month-end close covers the habit in depth. Accrued expenses are costs incurred in the month and still unbilled, such as freight. Your co-packer batch made in September and billed in October goes on the September books as inventory. Its cost moves to cost of goods sold when the product sells.
How Do You Close Inventory Held at a Co-Packer or 3PL?
Close inventory held at a co-packer or 3PL by adjusting your books to each partner’s month-end inventory report. Record the difference in cost of goods sold.
The 3PL inventory reconciliation happens on day 3, alongside the same match for co-packer inventory. Shrinkage is the gap between inventory on the books and inventory on hand.
| Shrinkage |
|---|
| = |
| Inventory on the books − Inventory on the partners’ reports |
| Day 3 inventory match | Amount |
|---|---|
| Inventory on the books | $287,380 |
| 3PL and co-packer reports combined | $279,900 |
| Shrinkage added to cost of goods sold | $7,480 |
Here, $7,480 lands in September and lowers September’s gross margin. I worked the 2023 harvest as a cellar hand at Trinchero Family Estates in Napa, where inventory is physical product before it becomes a number.
Tag packaging and short-dated stock while you reconcile, because lenders often exclude aged inventory, and check how your loan agreement treats packaging. The FDIC’s examination procedures list shelf life and obsolescence among the inventory items field audits review, and they mark work in process as typically excluded. Our brand’s agreement excludes $41,900 of printed cans and short-dated stock as ineligible, and tagging it on day 3 shows what your lender will set aside.
How Do You Match Distributor Deductions to Trade Spend During the Close?
Match each distributor deduction to the promotion it pays for, and clear matched amounts against your trade spend accrual. Flag the rest before the borrowing base certificate goes out.
Your trade spend accrual is your estimate of what you owe for promotions that already happened and still await their deductions. The match compares each deduction’s promotion, dates, product, and per-case rate with the promotion agreement. I get stoked when a deduction lands on its exact promotion line.
September’s remittances carry $40,900 in deductions. The close matches $23,600 of them to July and August promotions. The other $17,300 stays open on the receivables aging report, flagged for backup or dispute.
| Ending trade spend accrual |
|---|
| = |
| Opening accrual + New promotions − Matched deductions |
| Trade spend accrual roll-forward | Amount |
|---|---|
| Accrual on September 1 | $31,200 |
| September promotion, 4,950 cases × $4.00 | $19,800 |
| Deductions matched to July and August promotions | −$23,600 |
| Accrual on September 30 | $27,400 |
Dilution is the share of billed sales that credits, discounts, returns, and deductions take out of receivables. When dilution is high, a lender can lower what it advances against receivables. Cultivar’s view is that trade spend, margin, cash flow, and borrowing usually get treated as separate topics, and one afternoon of deduction matching moves all four.
What Happens on Day 5?
Day 5 is a review against last month’s statements, then a QuickBooks Online closing date that locks September. When you set it, choose “Allow changes after viewing a warning and entering password,” per Intuit’s help article updated September 15, 2026.
How Do You Calculate the Borrowing Base at the End of the Close?
Calculate the borrowing base by applying your agreement’s advance rates to eligible receivables and eligible inventory. Subtract your outstanding balance, and you see what you can still draw.
Day 6 is the lender package, the last stop on your month-end close checklist.
Eligible receivables are the receivables your agreement accepts as collateral after exclusions. Exclusions differ by agreement, and our example agreement excludes receivables more than 90 days past invoice plus any disputed or short-paid amounts. The FDIC’s procedures for how examiners review asset-based loans say these loans usually include borrowing base certificates and field audits. Examiners then check that those field audits cover ineligible receivables, which are the exclusions your certificate subtracts.
| Borrowing base calculation | Math | Amount |
|---|---|---|
| Receivables on September 30 | $346,000 | |
| Less receivables more than 90 days past invoice | −$11,700 | |
| Less deductions flagged on day 4 | −$17,300 | |
| Eligible receivables | $317,000 | |
| Receivables availability at 80% | 80% × $317,000 | $253,600 |
| Counted inventory | $279,900 | |
| Less printed cans and short-dated stock | −$41,900 | |
| Eligible inventory | $238,000 | |
| Inventory availability at 45% | 45% × $238,000 | $107,100 |
| Borrowing base | $253,600 + $107,100 | $360,700 |
| Less line balance on September 30 | −$318,000 | |
| Available to draw | $360,700 − $318,000 | $42,700 |
Our $360,700 borrowing base sits under the $425,000 line limit, so the borrowing base sets the cap on what the brand can draw. Counting the $17,300 as eligible would overstate availability by 80% × $17,300 = $13,840 and show $56,540 available to draw against the true $42,700. Drawing the full $56,540 would leave a $13,840 over-advance, which is a balance above the borrowing base. I treat the day 4 flags as the most valuable lines in this borrowing base calculation for exactly that reason.
Caption: Send this list to your bookkeeper and do all six checks before every signature.
How Do You Make Next Month’s Close Easier?
Before next month’s close, pick your lender’s earliest deadline and confirm that business day 6 lands several business days ahead of it.
Our example brand now sends its September certificate on day 6, a full week ahead of the October 15 deadline. Your month-end close checklist works this smoothly when it rests on a chart of accounts and systems built for CPG. Cultivar built UNDONE’s U.S. back office in under three months, scalable chart of accounts included.
Book November’s close for Tuesday, December 1 through Tuesday, December 8, give each of the six days one owner, ask your 3PL for its inventory report in the last week of November, and send the calendar to your lender contact.
If your borrowing base certificate is due before your books are closed, book a call with me and the Cultivar accounting team, and let’s set up a monthly close that gets your lender package out on time.
Frequently Asked Questions
What Happens If I Miss My Borrowing Base Certificate Deadline?
Your loan agreement spells out what follows a missed reporting date, so read that section before the month starts. Starting your close on the first business day and finishing on business day 6 protects that date every month.
Can Inventory at My Co-Packer or 3PL Count Toward My Borrowing Base?
Partner-held inventory counts when your loan agreement treats it as eligible, at the agreement’s advance rate. In our example, $279,900 of counted inventory minus $41,900 of printed cans and short-dated stock leaves $238,000 eligible.
How Do I Estimate a Trade Spend Accrual Before the Distributor Deducts It?
Multiply the cases each promotion covers by its per-case rate in the promotion agreement. Our September promotion added 4,950 cases × $4.00 = $19,800 to the accrual.
Can a Part-Time Bookkeeper Close the Books for a CPG Brand Every Month?
Yes, when the close follows a fixed calendar with one owner for each day. Six business days give a small team room before a 15th-of-the-month lender deadline.
Related Resources
- CPG trade spend management at Cultivar puts every chargeback and deduction through verification and works with distributors to recover lost dollars.
- Pedro’s post on what a deduction dispute is worth shows how unresolved deductions on an A/R aging can lead an asset-based lender to apply a dilution haircut.
- Pistakio’s rebuilt chart of accounts let Nico read margin and COGS alongside cash flow at a glance as he prepared for an equity raise.
About the author
Cristian Iriart
Accountant, Cultivar · Public accountant (Argentina) · Former PwC tax senior
Cristian Iriart is an Accountant at Cultivar, where he has supported US accounting operations for CPG brands since 2023, including accounts payable and receivable, bank reconciliations, expense management, invoicing, and the month-end close. Before joining Cultivar, he spent nearly four years as a senior in PwC Argentina’s tax practice and worked the 2023 harvest as a cellar hand at Trinchero Family Estates in Napa. Cristian is a national public accountant in Argentina (Contador Público Nacional) and a graduate of Universidad Nacional de Cuyo.