Skip to main content
+1 (945) 382-5060 info@fuelcfo.com
Lottery from Modisoft to your books

Modisoft Lottery: How to Account for It in QuickBooks

Lottery passes through the register but most of it is not your income. This page explains what a Modisoft lottery report shows, what belongs in your books, and how to keep lottery from inflating your revenue.

Works with your POS, back-office & accounting stack

Gilbarco Verifone CStoreOffice PDI SSCS Petrosoft Modisoft CSympl QuickBooks Xero Sage Intacct

How Modisoft lottery fits into your accounting

Lottery is one of the most commonly mis-recorded items in a gas station's books. Most of what you take in belongs to the lottery, not to you. Modisoft offers lottery features at the register and in reports, so this page covers what to take from it. Confirm the exact reports and settings in your setup with Modisoft.

What the register records

Draw game and scratch-off sales are rung up at the register and recorded separately from store items. Winning tickets paid out at the counter are recorded as payouts.

What is yours and what is not

Most lottery sales are held for the lottery and settled with it on a schedule. Your income is the commission you earn, not the full sales amount.

How it should look in the books

Lottery sales and payouts go through a liability account. The commission is recorded as income. The settlement to the lottery clears the liability.

What goes wrong

When lottery is counted as sales, revenue is overstated, margins look wrong, and the amount owed to the lottery is not tracked.

How to use this page

To see which lottery numbers to pull, go to the lottery reports. To see what goes wrong, go to where it goes wrong. If you want a team to handle it, what we do covers it.

Next steps

What we do with your lottery numbers

1

Separate lottery from sales

Lottery sales and payouts go to a liability account, not income.

2

Record the commission

The commission you earn is booked as income.

3

Match the settlement

Payments to the lottery are matched to the amount owed.

4

Watch the balance

The lottery liability is checked each month so it does not drift.

Book a Free Books Review

FinTruction · 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 Campbell Oniel Campbell
Founder, 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 Mayberry Dalton Mayberry
Owner, ProperCoat Painting
Carl Moore

"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."

Rolian Rolian
Owner, 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 Pearson Clay Pearson
Owner, C. Pearson Contracting Corp

Book a Free Books Review

How we handle lottery each month

1

We collect the reports

Modisoft lottery reports and the lottery settlement statements.

2

We split it out

Lottery sales and payouts are removed from store income.

3

We post the liability

Net amounts owed are recorded in a liability account.

4

We match the settlement

Payments to the lottery clear the liability.

5

We report

You get the books and a note on any lottery difference and its cause.

Modisoft lottery numbers to pull each month

What we needWhat it tells usWhere it goes in the books
Draw game salesDaily draw game totalLottery liability
Scratch-off salesDaily instant ticket totalLottery liability
Winner payoutsPrizes paid at the counterReduces lottery liability
CommissionWhat you earn on salesCommission income
Lottery settlementWhat the lottery collected from youClears the liability
Lottery over and shortDifferences at the registerOver and short, reviewed

Report names and layouts vary by store setup and state lottery. Ask Modisoft what yours are called.

Where lottery goes wrong in the books

Lottery counted as sales

Revenue is overstated by the full amount of lottery sales.

Payouts not recorded

Winners paid at the counter are never deducted.

Commission lost

The commission is buried inside sales or never recorded.

Settlement not matched

The payment to the lottery is booked as an expense instead of clearing the liability.

A liability that drifts

The balance grows or shrinks and nobody knows why.

Timing

Settlements that fall after month-end land in the wrong month.

Lottery inside sales vs lottery as a liability

Inside salesFuelCFO
RevenueOverstatedShows only what is yours
PayoutsMissedDeducted from the liability
CommissionBuried in salesRecorded as income
SettlementBooked as an expenseClears the liability
BalanceUnknownChecked every month
ResultMargins that look wrongBooks you can trust

Who this page is for

Owners selling lottery

You want to know how it should look in the books.

Owners with odd margins

Your store margin looks too low or too high and lottery may be the reason.

Stores with a lottery balance that drifts

The amount owed does not match what the lottery says.

Where the numbers move

Records lottery salesModisoft registerDraw and instant
Sales, payouts, commissionLottery reportTotals the day
Your booksQuickBooks OnlineLiability and income

What to have ready

  • Your Modisoft lottery reports and lottery settlement statements
  • Access to your QuickBooks Online file
  • Bank, card processor and fleet card statements
  • A note of how Modisoft totals get into QuickBooks today

If you are not sure how lottery is recorded today, tell us and we will work it out.

Starting with us

1

The free 48-hour book review

A 30-minute call, then about 48 hours while we review your books. You get our findings and a plain explanation of how we would fix them.

2

Map your lottery accounts

We agree which Modisoft report feeds which account and document it.

3

Your first monthly close

The first month is reconciled, closed and reported, then it runs on a schedule.

FAQ

Frequently asked questions

Lottery sales and payouts should go through a liability account, with the commission you earn recorded as income and the settlement to the lottery clearing the liability. Ask your accountant, or us, to confirm the setup for your state.
Mostly no. Most of the sales amount is held for the lottery. Your income is the commission you earn.
Modisoft offers lottery features, and searches for Modisoft lottery management are common. Which features and reports you have depends on your setup, so confirm them with Modisoft.
If lottery sales are counted as store sales, revenue is overstated and margin is understated. Separating lottery usually fixes it.
Common causes are missed payouts, timing across month-end, and settlements booked as expenses. We trace the difference to its cause each month.
No. We work from your existing Modisoft reports, your lottery statements and your QuickBooks Online file.

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? WhatsApp us or email info@fuelcfo.com.