Your Reward Card

Reconciling YourRewardCard Transactions with QuickBooks in Five Steps

Tying prepaid card activity to supplier bills and payroll in QuickBooks is a familiar headache for Australian finance teams. A clean reconciliation shows what YourRewardCard actually spent and what QuickBooks has recorded, so month-end closes without a lucky guess.

Businesses here often juggle AUD payments, GST reporting, company cards and staff reimbursements. The workflow may differ between a Melbourne office and a regional supplier in Queensland, but every transaction still needs a business purpose, the correct expense category and an audit trail.

QuickBooks works best when incoming data follows predictable rules. YourRewardCard helps cardholders check balances, load funds and manage spending; pairing those records with QuickBooks becomes quicker once export timing, account mapping and naming conventions are agreed.

This guide sets out reconciling YourRewardCard transactions with QuickBooks in a five-step routine while accounting for GST, the Australian financial year and the differences between bank payments and prepaid-card spending.

Prepare access and agree the rules

The first step is to agree the scope. Open the correct QuickBooks company file, choose a statement period and nominate one reconciliation owner. Use a dedicated prepaid-card clearing account where possible rather than mixing card spending with the operating bank account.

Before matching anything, confirm the following:

Create a company-wide card policy that explains who can load funds, which purchases need approval and where receipts go. This keeps personal top-ups and duplicate claims out of the ledger and gives staff a clear rule they can actually follow.

Record the opening card balance and unspent funds before matching anything. Treat a load from the operating account as a transfer, not an expense; the later purchase is what becomes a cost, asset or another appropriate account.

Export and classify card activity

The second step is to export the chosen period after the activity has finalised. Check that the file includes both the original transaction date and the posted date, because a purchase at 11 pm can appear on a different calendar date after processing.

Capture the following details for every transaction:

Keep foreign-currency details rather than replacing them with a rounded AUD figure. Where the merchant descriptor differs from the supplier record—for example, a Coles purchase against a staff expense claim—use the receipt and policy to identify the correct entry.

Classify loads separately from spending. A debit from the business bank account increases the prepaid balance, while a purchase reduces it. In QuickBooks, use transfers and clearing entries to show both sides without counting the same money twice.

Match transactions to QuickBooks records

The third step is matching. Compare amount, date, reference and merchant before accepting a transaction. Use the connected QuickBooks import where its available fields meet your needs; otherwise import a CSV and review the mapping. Consistent naming and correct GST codes matter more than speed.

Watch for timing differences across month-end, weekends and daylight-saving changes. A transaction posted on 1 July may belong to the June reporting period for management reporting, even though it clears in QuickBooks in July.

Handle bills and reimbursements with care. If a supplier invoice is paid by card, match the bill payment to the card transaction without adding the supplier expense twice. Employee claims need a receipt and an approved purpose, not merely a cardholder name.

Resolve unmatched and disputed entries

The fourth step is to clear the exceptions. Do not force a match simply to make the report look tidy. Investigate pending transactions, duplicates, declined payments and refunds, then decide whether each needs a correction, an adjustment or a note for the next review.

Separate common exceptions into their own review queue:

Keep GST analysis separate from card matching. A card purchase is not automatically GST-free: check the invoice and tax code, and do not claim GST twice. Review any GST charged on service fees, including whether a reduced GST limit applies to your business.

Record every adjustment with a reason and evidence. If an expense arrives after the reporting cut-off, post it in the right period or disclose the timing difference. This is especially important when the team is preparing a quarterly BAS or a 30 June year-end.

Finalise and document the reconciliation

The fifth step is to reconcile the totals. Compare the net cleared card activity, including fees and refunds where applicable, with the relevant QuickBooks clearing account. The card’s current balance may not be nil because it includes unspent funds and pending activity.

Save a reconciliation report showing the period, owner, matched total, exceptions and approval date. Keep the YourRewardCard statement and receipts together. A short note explaining recurring timing differences prevents the same question being asked every month.

Then lock the reviewed period in QuickBooks and retain a clear audit trail. For a larger business, a second reviewer should sample transactions, cardholder limits and receipts rather than rely solely on the person who completed the match.

Make reconciliation a routine that sticks

Treat the process as a weekly recon, with a deeper review before payroll, quarterly BAS and the 30 June financial-year close. Short, frequent checks expose missing receipts while there is still time to chase them, rather than leaving everything until the finance team is chasing spreadsheets at 4:55 pm.

If reconciliation highlights a working-capital gap, funding is a separate decision from bookkeeping. Loans on Click can be a place to explore short-term finance options, but compare costs and repayment capacity before committing. Start with one completed period today: open the last statement, agree the account mapping, clear the exceptions and schedule the next review.