How to Do a Month-End Close? Training on a Bookkeeping Closing Checklist, Reconciliations and Monthly Reporting
How do you do a month-end close? Invoice, cash, bank, account and inventory checks, a closing schedule and a monthly report: an 8-lesson bookkeeping checklist with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is a month-end close, and why is it done?
- Lesson 2: How do you set up a month-end closing schedule?
- Lesson 3: How are sales and invoices checked?
- Lesson 4: How are cash, bank and collections checked?
- Lesson 5: How are customer and supplier accounts checked?
- Lesson 6: How are expenses and inventory checked?
- Lesson 7: How is the monthly closing report prepared?
- Lesson 8: How is the month locked, and how are open items carried forward?
- What are the most common mistakes in the month-end close?
- How does NetKasam make the month-end close easier?
- Mini quiz: Test what you have learned
- Conclusion: Put your closing schedule in writing this month
- Frequently Asked Questions About the Month-End Close
It is the last day of the month and the accountant calls: "Is anything missing for October's close?" You don't know either. Have all invoices been issued? Does the bank statement match the records? Are customer balances correct? Has the stock count been done? Every month you hunt for the answers to these questions, every month something turns out to be missing, and the close takes a week. The solution is not to work harder but to tie the month-end close to a checklist: every task has a set order, an owner and a deadline.
This article is not a lecture but an 8-lesson hands-on training. We will answer how to do a month-end close through a sample month, working in order through the closing schedule, sales and invoice checks, cash-bank-account reconciliations, expense and inventory checks, the monthly closing report and the post-close routine. Each lesson links to the detailed guides on this site; here you see how they all come together. At the end there is a mini quiz and a separate printable checklist. Because tax return and filing schedules vary from business to business, this article does not give legal dates; consult your certified public accountant (mali müşavir) for those.
What will you be able to do by the end of this training?
In short: You will set up a month-end closing schedule, apply the five groups of checks in order, list and clear open items, prepare the monthly closing report and speed up the process for the next month.
- 01ScheduleSet the closing days and who is responsible.
- 02InvoicesConfirm that every order has been invoiced.
- 03ReconciliationMatch cash, bank and account balances.
- 04Expenses and inventoryDocument expenses and clear stock differences.
- 05ReportProduce the monthly closing report.
- 06LockCarry forward open items, lock the month and archive.
The 8 lessons of the training: (1) what a close is, (2) the closing schedule, (3) sales and invoice checks, (4) cash, bank and collections, (5) customer and supplier accounts, (6) expenses and inventory, (7) the monthly closing report, (8) locking, carrying forward and continuous improvement.
Lesson 1: What is a month-end close, and why is it done?
In short: The month-end close is the process of confirming that all of the month's revenue, expense, collection, payment and stock transactions have been recorded, that they agree with each other, and that the month will no longer change. Reliable monthly results are a precondition for decision-making and legal obligations. For the general concept, see also the glossary term period-end procedures in accounting.
| Without a close | Result | With a close |
|---|---|---|
| Missing invoices go unnoticed | Revenue looks understated, risk of document penalties | The number of invoices is compared with the number of orders |
| Bank differences pile up | Cash information is unreliable | Monthly reconciliation brings the difference to zero |
| Account balances don't match | Collections are delayed, disputes grow | Balances are confirmed, due dates are tracked |
| Expenses remain undocumented | Unrecorded spending | All expenses are recorded with documents |
| Reports arrive late | Decisions are made with old data | The report is ready in the first week of the month |
Issuing invoices on time is a separate rule: see the article within how many days must an invoice be issued. The close should be not the last stop for catching an invoice that should have been issued but wasn't, but the final safeguard.
Lesson 2: How do you set up a month-end closing schedule?
In short: Plan the close not as a one-day "big job" but as a schedule that starts in the last business days of the month and ends in the first week of the next. Write down the owner and deadline of each step.
| Day | Step | Responsible | Output |
|---|---|---|---|
| Month-end −2 to month-end | Invoice pending orders, process cancellations and returns, do the cash count | Sales, warehouse, cashier | No uninvoiced orders |
| Month-end +1 | Get the bank statement; start the cash and bank reconciliation | Accounting | Open items list |
| Month-end +2 | Confirm account balances, flag overdue items, document expenses | Accounting | Account and expense list |
| Month-end +3 | Clear stock differences and negative stock | Warehouse, accounting | Inventory sign-off |
| Month-end +4 | Produce the closing report, explain variances | Accounting | Monthly report |
| Month-end +5 | Manager approval, lock the month, carry forward open items | Manager | Closed month |
This schedule is an example; it can be compressed or expanded depending on the size of your business. What matters is that every task has an owner and a deadline. For permissions and task allocation, see the article user permissions.
Lesson 3: How are sales and invoices checked?
In short: Compare the number of orders fulfilled during the month with the number of invoices issued. After deducting cancellations, the remaining difference is uninvoiced orders, and it should be cleared before closing.
Sample month (the figures were chosen only to illustrate the method): 1,240 orders in total across the store, marketplaces and website, 18 cancelled, 1,208 invoices issued.
- Monthly orders1,240
- Cancelled orders−18
- Orders to be invoiced1,222
Prepared with sample values. Invoices issued: 1,208; difference: 14 orders.
| Control | How? | Sample result |
|---|---|---|
| Orders − cancellations = to be invoiced | Count from the order report | 1.240 − 18 = 1.222 |
| Number of invoices issued | Count from the invoice report | 1.208 |
| Difference = missing invoices | The difference between the two numbers | 14 orders |
| Return invoice check | Is there a return invoice for every returned order? | List the missing ones |
| Duplicate invoice check | Are there two invoices for the same order? | If so, cancel or return |
The reasons for the 14 missing invoices are investigated (not issued, issued incorrectly, or issued on a different channel?) and the ones that need to be issued are issued right away. For cancellation and return documents, see the articles how to cancel an order and how to issue a return invoice. In NetKasam you can filter your orders and move them in bulk into the waybill, invoice or e-Invoice process (can I convert to invoices in bulk); for accounting for marketplace sales, take a look at the article marketplace accounting.
Recommended readingHow to Do Marketplace Accounting?Lesson 4: How are cash, bank and collections checked?
In short: At the end of the month, the cash is counted, the bank statement is matched with the records, and card, bank transfer and marketplace collections are confirmed as having reached the account. The month does not close until both reconciliations close with zero difference.
| Control | How? | Guide |
|---|---|---|
| Cash count | Compare expected cash with counted cash | cash register closing |
| Bank reconciliation | Match the statement balance with the records in a two-sided table | bank reconciliation |
| Card collections | Compare the POS report with the net amount credited to the account | payment by link |
| Marketplace payout | Match the payout report with the bank deposit | marketplace accounting |
| Cheques and promissory notes | Close cheques that have come due and been collected | cheque and promissory note tracking |
At the end of the sample month, the cash count showed a difference of −₺60 (a cash shortage, cause found); the raw difference in the bank reconciliation was −₺2,750, and the two sides were brought into balance with ₺12,000 in collections in transit, ₺9,600 in outstanding cheques and ₺350 in unrecorded bank charges. The only item with a recording difference is the ₺350 charge; in NetKasam, an expense voucher is created automatically by the system for bank charges arising from collections or payments (how can I create my bank charges).
Lesson 5: How are customer and supplier accounts checked?
In short: At the end of the month, the balance of every significant customer and supplier is confirmed, overdue items are flagged and reconciliation is started for accounts where there is a difference with the other party.
- Pull the balance list: Get customer and supplier balances in a single table.
- Flag overdue items: Separate receivables more than 30 days overdue in the aging table.
- Send reconciliations for large balances: Share the statement and ask for the other party's balance.
- Classify the differences: Is it a return, collection, invoice or recording difference?
- Send reminders: Collection reminders for overdue items.
Sample month: of 40 active accounts, 3 showed a balance difference with the other party; the largest was an unrecorded return invoice of ₺2,400. In NetKasam you can quickly create and share account statements for month-end reconciliation and send a reconciliation letter with a single click (how do I reconcile accounts). For the detailed method, see the articles how to track customer and supplier accounts and what is account reconciliation and how is it done. For the financing cost of credit receivables, the article late payment charges is helpful.
Lesson 6: How are expenses and inventory checked?
In short: On the expense side, you confirm that every expenditure is documented and in the right category; on the inventory side, that there is no negative stock or count difference. A month in which expense and stock differences are not cleared distorts the profit calculation.
| Area | Control | Sample problem | Solution |
|---|---|---|---|
| Expenses | Are there undocumented expenses? | Paid from the cash register, no receipt | Find the document or create an expense voucher |
| Expenses | Is it the right category? | Rent recorded under "other" | Correct the category |
| Expenses | Are any payments due? | Unpaid invoice | Add it to the cash plan |
| Inventory | Is there negative stock? | Sales recorded, no receipt entry | Record the receipt entry |
| Inventory | Is there a count difference? | Shelf and records don't match | Difference entry and reason |
| Inventory | Is there dead stock? | Aging product | Clearance plan |
- Sales and invoice check3.0 hours
- Bank and cash reconciliation2.5 hours
- Account check2.0 hours
- Inventory check2.0 hours
- Expense check1.5 hours
- Report and approval1.0 hours
Prepared with sample values. Total 12 hours.
For stock differences, see how to do a stock count and how to clear dead stock, and for expense tracking, the expense management page. In NetKasam, when you cancel an expense voucher, all of the transaction's movements are updated with a reversing entry (can I cancel expense vouchers); a reversing entry instead of deletion does not alter the history of a closed month.
Lesson 7: How is the monthly closing report prepared?
In short: The closing report shows net sales, gross profit, expenses, net result, cash position and open items on a single page. Compared with the previous month and the same month last year, variances become visible immediately.
- Net sales = Gross sales − Returns − Cancellations
- Gross profit = Net sales − Cost of goods sold
- Net result = Gross profit − Expenses
- Net margin = Net result ÷ Net sales
- Net cash flow = Collections − Payments
- Number of open items = Invoicing + bank + account + inventory + expense gaps
The number of open items is a quality indicator; the goal is for it to fall every month.
| Item | October (example) | September | Change |
|---|---|---|---|
| Net sales | 1.350.000 ₺ | 1.260.000 ₺ | +%7,1 |
| Gross profit | 483.000 ₺ | 440.000 ₺ | +%9,8 |
| Expenses | 355.000 ₺ | 340.000 ₺ | +%4,4 |
| Net result | 128.000 ₺ | 100.000 ₺ | +%28,0 |
| Net margin | %9,5 | %7,9 | +1.6 points |
| Number of open items | 40 | 56 | −16 |
- Missing invoices₺1435%
- Bank and collections₺922.5%
- Account differences₺717.5%
- Inventory₺615%
- Expenses₺410%
Prepared with sample values. Each type corresponds to a group of checks.
In the example, the net result is 483,000 − 355,000 = ₺128,000; the net margin is 128,000 ÷ 1,350,000 = 9.5%. For the structure of the income statement, see how to prepare an income statement; for the cash side, how to prepare a cash flow statement; and for results by branch, branch-level profitability. In NetKasam you create the reports you need with criteria and save them, pull them every month with the same filter in one click and export them to Excel (reports).
Lesson 8: How is the month locked, and how are open items carried forward?
In short: Once reconciliations are complete and the report is approved, lock the month: later corrections should be made only with manager approval and through reversing entries. Open items that cannot be closed are carried forward to the next month with a list.
- Get manager approval: Have the manager review the report and open items.
- List the items that cannot be closed: Write a reason, an owner and a target date for each item.
- Lock the month: Restrict new entries to the closed period through permissions.
- Archive the documents: Keep statements, reconciliations, count sheets and the report in the same folder.
- Write down the improvement: Set a measure for next month for the group of checks that produced the most open items.
| When? | What to do? | Who? |
|---|---|---|
| Every day | Record transactions immediately (invoices, collections, expenses, inventory) | Everyone |
| Every week | Check open items and uninvoiced orders | Accounting |
| Month-end | Follow the closing schedule | Accounting, manager |
| Month-end +5 | Approve the report, lock the month | Manager |
| Once a quarter | Review closing time and the number of open items | Management |
- 14uninvoiced orders (1,222 − 1,208)
- ₺0$0bank reconciliation difference (after adjustments)
- 40open items (56 the previous month)
- 12 hourstotal time spent on the close
Locking requires permission control: decide who can make entries to a closed period with the permission matrix in the article user permissions. The way to speed things up is regular recording; for how to migrate old records when switching to a new system, see the article data migration when changing accounting software.
Recommended readingCan Bookkeeping Be Done in Excel? A 5-Sheet Template, Ready-Made Formulas, Excel's Limits and the Threshold for Switching to Bookkeeping SoftwareWhat are the most common mistakes in the month-end close?
- Leaving records until the end of the month. The close takes days.
- Not comparing the number of orders and invoices. Missing invoices go unnoticed.
- Skipping the bank reconciliation. Cash information remains unreliable.
- Not confirming account balances. Discrepancies pile up.
- Postponing stock differences. The profit calculation is distorted.
- Not locking the month. Entries slip quietly into the closed month and the report changes.
- Carrying forward open items without listing them. The same problem comes up again every month.
How does NetKasam make the month-end close easier?
- Orders on one screen. You track marketplace and e-commerce orders in one panel and invoice them in bulk (order management).
- Invoice tracking. You create and track the invoices you issue (invoice tracking).
- Automatic cash and bank entries. Cash and bank entries are created at the same time as transactions, and bank charges become expense vouchers.
- Account statements and reconciliation. You share statements, send reconciliation letters with a single click and get due-date reminders (customer and supplier account tracking).
- Stock movements and reorder levels. You track stock movements on one screen and set reorder quantities (inventory management).
- Saved reports. You save monthly reports, pull them every month with the same criteria and export them to Excel.
- Undeletable activity log and permissions. Every action users take is logged; you manage permissions down to the finest detail.
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If there are 800 orders, 12 cancellations and 775 invoices, how many invoices are missing?
- If net sales are ₺900,000, gross profit ₺315,000 and expenses ₺240,000, what are the net result and net margin?
- Why does the close stop if the bank statement balance differs from the records?
- What is the purpose of locking the month?
- What is the most important habit that speeds up the close?
Answer key:
- 800 − 12 = 788 should be invoiced; 788 − 775 = 13 invoices missing.
- 315.000 − 240.000 = 75.000 ₺; 75.000 ÷ 900.000 = %8,3.
- Until the difference is explained, cash information cannot be trusted; timing and recording differences must be separated and corrected, and the two sides brought into balance.
- To prevent quiet entries into the closed period and ensure the report does not change.
- Recording transactions during the day rather than leaving them until the end of the month.
Frequently Asked Questions About the Month-End Close
How do you do a month-end close?
Five groups of checks are applied on a schedule that starts in the last days of the month and ends in the first week of the next: sales and invoices, cash and bank, customer and supplier accounts, expenses and inventory. At the end, a closing report is produced, the manager approves it and the month is locked.
What should a month-end closing checklist include?
No orders without invoices, cancellation and return documents complete, cash count done, bank reconciliation closed with zero difference, account balances confirmed, expenses documented, no negative stock or count differences, and the closing report approved.
How do you find invoices that have not been issued?
Subtract cancellations from the number of orders and compare with the number of invoices issued. The difference is the number of uninvoiced orders, and it should be cleared before closing.
How many days should a month-end close take?
If records are made during the day, a few business days are enough. If records are left until the end of the month, it takes more than a week. What matters is that the time gets shorter every month.
Can entries be made to a closed month later?
Only with manager approval, and preferably through a reversing or correcting entry. A closed month should be protected by permissions.
What are the tax return and filing dates?
This article does not give legal dates. Because the dates vary by business type, consult your certified public accountant (mali müşavir).
Can I send reconciliation letters in NetKasam?
Yes. You can quickly create and share your account statements and send your reconciliation letter with a single click at the end of the month.
Can I save reports in NetKasam?
Yes. You save the criteria of reports you pull regularly, access the reports later with the same criteria in one click, and export them to Excel if you wish.
Conclusion: Put your closing schedule in writing this month
The month-end close is not an act of heroism but a schedule. This month, write the closing steps on one page with their owners and deadlines, start by comparing the number of orders and invoices, and note the number of open items at the end. Aim to bring that number down next month; three months from now, your close will be measured in hours.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.