Closing before everything is reconciled
A month locked while a bank or card clearing account is unreconciled carries errors into every later month.
Do this insteadReconcile every bank, card and fleet clearing account first, then lock the period.
Free XLSX template
Gas Station Month-End Close Checklist
A closing routine you can follow in the same order every month. It covers the parts of a gas station close that generic checklists miss: fuel gallons, card and fleet settlement, lottery, gift cards and sales tax.
Free download
XLSX file
Works in Excel & Google Sheets
Any POS system
XLSX
Download the template
Free. Enter your details and the file downloads straight away.
We may follow up about your books. No spam.
What you get
What this template tells you
- Exactly which tasks are done, in progress or not started, and what percentage of the close is finished.
- Who owns each task and by which business day it is due.
- Why each task matters, so a new bookkeeper understands the reason as well as the step.
Step by step
How to fill it in
Yellow cells are for you to fill in. Pick a status for each task and the progress score updates itself.
-
1
Name the month
Enter the month you are closing and who is preparing it.
-
2
Work section by section
Start with sales and POS, then fuel, banking, other store money, inventory, taxes and review.
-
3
Set the status
Pick Not started, In progress, Done or N/A from the drop-down. Rows color as you go and the progress score updates.
-
4
Add owners and dates
Fill in who is responsible and the date done, and use the notes column for anything you could not place.
-
5
Lock the month
When every task is done, lock the period in your accounting software and keep the supporting documents.
Reading the result
What good and bad look like
A healthy result
The close is finished by the 10th to 15th business day of the next month, every task has an owner, and the notes column explains anything unusual instead of leaving it unexplained.
Warning signs
Tasks are skipped under time pressure, the bank is reconciled but fuel gallons are not, or the month is closed with unexplained items sitting in clearing accounts.
Avoid these
Common mistakes
Skipping the fuel tie-out
Totals can look reasonable while gallons delivered, sold and left in the tanks disagree.
Do this insteadTie gallons by grade to invoices and tank readings every month, however good the totals look.
Letting lottery and sales tax balances sit
Both are owed to someone else. Unchecked balances grow, and a payment can arrive as a surprise.
Do this insteadCheck what is owed against the provider and state statements before the month closes.
Changing a closed month later
Quiet edits to old months make reports unreliable and are hard to explain to a lender or buyer.
Do this insteadLock the period, and record the reason and date for any adjustment you must make.
Keep going
Related guides and services
Resource
Service
Resource
QuickBooks integration for gas stations
Read more →
Service
Gas station bookkeeping: chart of accounts
A generic QuickBooks chart of accounts does not work for gas stations. You need fuel COGS by grade, store marg...
Explore service →
Resource
Gift card liability accounting
A gift card sale is not income. It is a promise to deliver goods later. Here is how to record sales, redemptio...
Read more →
Questions
Frequently asked questions
How long should a month-end close take?
Many stations aim to finish within 10 to 15 business days of month end. The faster you get your POS and bank data, the faster the close.
Can I delete tasks that do not apply?
Set them to N/A and they are left out of the progress score. That is better than deleting them, because the next month still has the full list.
Is this for QuickBooks users?
Yes. It works with any accounting software. Several tasks relate to making sure POS totals reach QuickBooks once each.
Who should use it?
Owners who do their own books, bookkeepers who are new to fuel retail, and accountants closing a station for the first time.
General guidance, not tax or accounting advice. Check figures against your own records.
A template cannot fix bad data
If the numbers you type in do not tie to your POS and bank, no spreadsheet will give you a true picture. Send us your last month and we will tell you what is wrong.
Get your free books reviewFinTruction · Construction Clients
Proof from our construction brand
Real US-based contractors. Same team, same operational discipline that we now bring to gas stations. Construction is a different vertical - but the muscle (multi-stream books, cost reconciliation, niche specialization) is the same one stations need.
"They didn't just record transactions and call it a day. They built a custom chart of accounts around how a remodeling company actually runs, did a full catch-up on years of bookkeeping inside QuickBooks Online, and now stay on top of my monthly bookkeeping and payroll."
Oniel CampbellFounder, Moonz Contracting
"Sahil and his team have been handling the bookkeeping and job costing for my painting business. They've done a great job cleaning up my books, using integrations to give me accurate, timely job costing and solid weekly data. Reliable, and the team is very detailed."
Dalton MayberryOwner, ProperCoat Painting
"They rebuilt the whole thing from the ground up, with real job costing, WIP, and retainage."
Carl Moore
Owner, Hearth & Haus
"They set the accounts up properly first, then cleaned up everything I never entered."
RolianOwner, Overtime Electric
"When I came to them I had no financial structure in place at all. No job costing, no WIP tracking, books were behind, no real way to tell if any job was actually making money. They came in, did a full cleanup, and set up job costing and WIP tracking inside QuickBooks."
Clay PearsonOwner, C. Pearson Contracting Corp
Book a Free Books Review
Find out what your numbers are really telling you.
Book a free books review. We'll look at your setup, show you what's missing, and tell you exactly how we'd fix it. No pressure, no obligation.
- 30-minute call, your time
- We look at a sample of your books
- Clear scope & pricing afterward
Prefer to skip the form?