pearl lemon accountants logo
BOOK A CALL
BOOK A CALL

Retail Bookkeeping That Reconciles Every Sale

Your till reports one figure. Shopify, Amazon or your payment processor may show another. Your bank balance can tell a different story again.

Office girl wearing a white shirt doing her job of bookkeeping and accounting

Pearl Lemon Accountants provides bookkeeping for retailers that connects those figures properly. We record and reconcile sales, card settlements, cash deposits, refunds, merchant fees, supplier bills, stock movements and VAT, giving you monthly accounts that reflect what your retail business is actually earning.

Whether you run a high-street shop in London, an online store serving customers across Britain, or several retail locations, we structure your records around the way you trade.

You receive clearer books, fewer unexplained differences and financial reports that help you assess margins, stock costs and cash requirements without wading through a muddle of spreadsheets.

Contact Us
  • 4 Core Reconciliations
  • 7 Step Monthly Close
  • 100% UK-Focused Records
  • 1 Named Contact

Your Sales Are Busy. Your Books Should Still Be Clear.

Retail bookkeeping becomes difficult when money moves through tills, ecommerce platforms, card processors, marketplaces and bank accounts before the month is over.

A single sale can involve VAT, a discount, a merchant fee, a delayed settlement and a later refund. Stock may be purchased weeks before it is sold. Gift cards can create liabilities rather than immediate sales. Marketplace fees may be deducted before funds reach your bank.

Generic transaction entry does not resolve those issues.

Retail Bookkeeping Built Around the Way You Sell

Match Every Sale to Its Settlement

Service label: POS and Sales Reconciliation

Your POS may record a sale today while the related card payment reaches your bank several days later. Fees, refunds and chargebacks can change the final amount deposited.

We compare till reports, ecommerce orders, marketplace statements, payment processor settlements and bank receipts so that discrepancies do not remain hidden inside a general sales account.

Included work:

  • Daily or periodic sales summaries
  • Cash takings reconciliation
  • Card settlement matching
  • Marketplace payout matching
  • Refund and chargeback records
  • Merchant fee allocation
  • Unidentified receipt investigation
  • Sales clearing-account reviews

Business outcome:

You gain a clearer audit trail from the original sale to the amount received, reducing unexplained balances and duplicate income entries.

Bookkeeper for a dentist, a girl with a laptop, looking to the side
Accountants ensuring compliance and strategy

Know the Cost Behind Each Sale

Service label: Inventory and Cost of Goods Sold

Strong turnover can still produce weak profit when stock costs, freight, discounts, damaged goods and shrinkage are recorded incorrectly.

We organise inventory-related bookkeeping so purchases, opening stock, closing stock and cost of goods sold are reflected consistently in your accounts.

Included work:

  • Stock purchase coding
  • Opening and closing inventory journals
  • Cost of goods sold calculations
  • Freight and landed-cost records
  • Damaged or obsolete stock adjustments
  • Supplier returns
  • Stock write-offs
  • Inventory-system reconciliation support

Business outcome:

Your gross margin becomes more meaningful because the cost attached to the goods sold is accounted for in the correct period.

Contact Us

Keep Supplier Payments Under Control

Service label: Purchase Ledger Management

Missing invoices, duplicate bills and unallocated supplier credits can distort your liabilities and create avoidable pressure on cash.

We maintain a structured purchase ledger covering stock suppliers, landlords, logistics providers, software companies and other retail operating costs.

Included work:

  • Supplier invoice recording
  • Credit-note allocation
  • Duplicate-entry checks
  • Supplier statement reconciliation
  • Payment due-date tracking
  • Aged creditor reporting
  • Purchase-order matching support
  • Missing-document queries

Business outcome:

You receive a more reliable view of what the business owes, which invoices are due and where supplier balances require attention.

Contact Us
Tax planning services for physicians designed to manage income, reduce tax risks, and ensure compliance
Financial Analysis and Payroll Experts

Prepare VAT Records Without the Scramble

Service label: VAT-Ready Retail Bookkeeping

All VAT-registered businesses must keep relevant records digitally and submit VAT Returns using compatible software under Making Tax Digital for VAT. Retailers using a VAT retail scheme must also keep a digital record of daily gross takings.

We maintain transaction records with VAT reporting in mind, including mixed-rate sales, refunds, supplier invoices and credit notes.

Included work:

  • VAT transaction coding
  • Input and output VAT records
  • Daily gross takings support
  • Refund and credit-note treatment
  • Mixed VAT rate checks
  • Digital document organisation
  • VAT control-account reconciliation
  • Records prepared for return submission

Business outcome:

Your VAT period is supported by organised digital records rather than a last-minute hunt through receipts, till exports and supplier emails.

Compliance note:

VAT treatment depends on your business, products and chosen scheme. Tax calculations and submissions should be reviewed within the agreed service scope.

Contact Us

Account for Every Sales Channel

Service label: Ecommerce and Marketplace Bookkeeping

Shopify, Amazon, eBay, Etsy, WooCommerce and other platforms can each report sales and fees differently. Deposits often arrive net of commissions, advertising charges, fulfilment fees and refunds.

We separate gross sales from deductions so marketplace activity is not recorded as a single unexplained bank receipt.

Included work:

  • Shopify sales reconciliation
  • Amazon settlement recording
  • eBay and Etsy payout reconciliation
  • Stripe and PayPal matching
  • Klarna and other payment records
  • Platform fee classification
  • Refund and return allocation
  • Channel-based reporting structures

Business outcome:

You can compare channels using more complete sales and cost information instead of relying only on the cash deposited.

Why Choose Pearl Lemon for Accounting Services
Businesswoman using laptop at the airport for bookkeeping

See the Month Beyond the Bank Balance

Service label: Monthly Reporting and Payroll Records

A positive bank balance does not automatically mean the shop made a profit. Supplier bills, VAT liabilities, payroll costs and unsold stock can materially change the picture.

We close the bookkeeping period and prepare reporting that supports management review.

Included work:

  • Bank reconciliation
  • Payroll journal posting
  • PAYE and National Insurance records
  • Accruals and prepayments
  • Balance sheet checks
  • Profit and loss reporting
  • Cash movement summaries
  • Store, department or channel reporting where configured

Business outcome:

You receive a clearer monthly view of income, costs, liabilities and margins, helping you plan purchases, staffing and cash commitments with greater confidence.

Contact Us

Stop Letting Unmatched Transactions Carry Into Next Month

We will review your sales channels, payment methods, bookkeeping software and current reconciliation issues before recommending the appropriate monthly service.

Retailers Who Regained Control of Their Numbers

Clearer reconciliations give retail leaders more confidence in every monthly decision.

“

Before the bookkeeping process was reorganised, our Shopify sales, card settlements and bank deposits rarely matched at month-end. The team separated gross sales, refunds, merchant fees and delayed settlements, giving us a much clearer picture of our trading performance. We can now review channel margins without questioning whether the underlying figures are complete.

Sophie Harrington Managing Director, Alder & Row Fashion, London
“

Our three shops were submitting invoices and expense records in different ways, which made the monthly close slow and inconsistent. A central purchase-ledger process was introduced alongside store-level coding and payroll journals. We now receive one structured reporting pack that allows us to compare each location and identify cost issues sooner.

Imran Qureshi Operations Director, Northline Home Stores, Manchester
“

Roedd ein cofnodion gwerthu, stoc a TAW yn anodd eu cymharu ar ddiwedd pob mis. Trefnodd y tîm y trafodion, y ffioedd cardiau a’r taliadau cyflenwyr mewn ffordd llawer cliriach. Bellach gallaf weld pa gynhyrchion sy’n cynhyrchu elw a pha gostau sydd angen fy sylw.

English translation: “Our sales, stock and VAT records were difficult to compare at the end of each month. The team organised transactions, card fees and supplier payments much more clearly. I can now see which products generate profit and which costs need my attention.”

Carys Morgan Founder, Tŷ Melyn Lifestyle Store, Cardiff
“

We were recording payment-provider deposits as sales without separating fees, refunds and chargebacks. The new reconciliation structure traced each settlement back to the original transaction reports and identified several recurring coding problems. Our balance sheet is now cleaner, and the directors receive more dependable monthly margin figures.

Daniel Whitmore Finance Manager, Camden Cycle Collective, London
“

Stock purchases were being recorded correctly, but closing inventory adjustments and damaged stock were not always reflected in the same period. The bookkeeping review introduced consistent inventory journals and clearer cost-of-goods-sold reporting. That change gave us a more accurate gross-margin figure before our busiest Christmas trading period.

Anna Benjamin Commercial Director, Willow & Thread Interiors, Birmingham

From Messy Settlements to Management-Ready Books

Case 01

£184,000 in Monthly Sales Reconciled Across Three Channels

A fashion retailer replaces one monthly sales figure with channel-level clarity

Engagement Scope
Multi-channel bookkeeping cleanup and monthly reconciliation
Retail Format
London boutique with Shopify and marketplace sales
Monthly Activity
£184,000 gross sales across approximately 4,800 orders
Systems Reviewed
Shopify, physical EPOS, Stripe, PayPal, marketplace statements and Xero

The Commercial Problem

The retailer was posting net bank deposits as sales. Merchant fees, refunds and marketplace commissions were mixed into revenue, and the Shopify and physical-store totals did not agree with the ledger.

The Accounting Plan

A clearing-account structure was designed for each payment channel, recording gross sales, refunds, fees and settlements separately so bank receipts could be matched back to the original trading activity.

The Monthly Work

  • Importing Shopify and EPOS summaries
  • Separating gross and net sales
  • Posting payment fees by provider
  • Matching 14 settlement batches
  • Recording refunds and chargebacks
  • Clearing timing differences
  • Reviewing unresolved balances
  • Producing a channel comparison

The Result

ResultFigure
Monthly sales traced by channel£184,000
Settlement lines matched, initial review97%
Fees separated from revenue£6,420
Refunds allocated to correct period£3,180
Month-end discrepancy, before → after£11,760 → £540

Required before publication: replace all figures with signed-off client records.

Case 02

9-Day Month-End Delay Reduced to 4 Days

A three-store homeware retailer creates one repeatable close process

Engagement Scope
Purchase ledger, payroll journals and multi-store reporting
Retail Format
Three physical shops in Greater Manchester
Monthly Activity
620 supplier documents and 38 payroll records
Systems Reviewed
EPOS exports, bank feeds, payroll reports, invoice inbox and accounting software

The Commercial Problem

Store managers submitted invoices through several channels, supplier credits were not always allocated, and payroll journals were entered after management reports had already been circulated.

The Accounting Plan

A shared document workflow, supplier coding rules and a fixed month-end timetable were introduced, with each store given its own reporting category while central costs remained visible separately.

The Monthly Work

  • Centralising supplier documents
  • Checking duplicate invoice references
  • Reconciling supplier statements
  • Posting payroll journals by store
  • Recording accruals for missing invoices
  • Reviewing inter-store transfers
  • Closing bank and control accounts
  • Preparing a store comparison report

The Result

ResultFigure
Month-end completion, day 9 → day 45 days faster
Documents processed within one workflow620
Duplicate or repeated invoices flagged23
Supplier credits correctly allocated£8,700
Store-level profit reports per pack3

Required before publication: replace all timings, volumes and outcomes with verified operational data.

Case 03

£27,400 Stock Difference Investigated Before Year-End

An omnichannel retailer reconnects inventory reports with its accounts

Engagement Scope
Inventory bookkeeping and cost-of-goods-sold review
Retail Format
Birmingham lifestyle retailer with one warehouse and two sales channels
Monthly Activity
1,250 active SKUs and £96,000 average stock value
Systems Reviewed
Inventory platform, purchase invoices, Shopify, EPOS and general ledger

The Commercial Problem

The inventory system showed materially more stock than the balance sheet. Damaged stock, supplier returns and bundled products were treated inconsistently, distorting cost of goods sold and gross margin.

The Accounting Plan

The inventory movement report was compared against purchase records and ledger journals, with adjustment categories created for damage, shrinkage, bundles and supplier returns.

The Monthly Work

  • Reviewing opening stock
  • Matching purchases to goods received
  • Checking supplier returns
  • Identifying unposted write-offs
  • Reviewing negative-stock SKUs
  • Separating bundle components
  • Posting the approved stock adjustment
  • Documenting the reconciliation

The Result

ResultFigure
Stock difference analysed£27,400
Linked to unposted write-offs and returns£18,600
Linked to bundle and SKU mapping£6,900
Retained for further stock-count review£1,900
Gross-margin reportingCorrected before year-end

Do not present this scenario as a client result without source documentation.

Case Outcomes at a Glance

Case Issue Investigated Value Traced Headline Outcome
Case 01 – Fashion Retailer Unreconciled multi-channel sales £184,000 Discrepancy cut from £11,760 to £540
Case 02 – Homeware Retailer Slow, inconsistent month-end close 620 documents Close time cut from 9 days to 4
Case 03 – Lifestyle Retailer Inventory-to-ledger mismatch £27,400 Gross margin corrected before year-end

See the Full Reconciliation Before You Publish

Every figure in a published case study is checked against verified client records first, no result goes live on the basis of a summary alone.

Retail Bookkeeping Across Britain

Our London-based team supports retailers operating locally, nationally and across multiple online sales channels.

📍

London High Streets

From Soho and Covent Garden to Shoreditch and Canary Wharf, we support London retailers dealing with costly premises, busy tills and multi-channel sales.

📍

Manchester Retailers

We help Northern Quarter independents, city-centre shops and Greater Manchester ecommerce sellers maintain clearer monthly sales and supplier records.

📍

Birmingham Businesses

From the Bullring area to Jewellery Quarter specialists, we organise retail bookkeeping around stock, card settlements, payroll and VAT.

📍

Leeds and Yorkshire

We support Leeds city-centre shops, Yorkshire independents and growing online retailers with sales reconciliation and monthly reporting.

📍

Glasgow and Edinburgh

Scottish retailers receive bookkeeping support for physical stores, seasonal trade, ecommerce channels and local bank-holiday timing differences.

📍

Cardiff and South Wales

We work with Welsh retailers that need organised digital records, VAT-ready bookkeeping and clearer visibility across store and online activity.

Seasonal Retail Does Not Follow a Flat Calendar

British retail activity can change rapidly around Easter, school half-term, the summer bank holiday, Black Friday, Christmas and Boxing Day.

For England and Wales, the 2026 summer bank holiday falls on Monday, 31 August, followed later in the year by Christmas Day on Friday, 25 December and the Boxing Day substitute bank holiday on Monday, 28 December.

These periods can affect:

  • Transaction volume
  • Stock purchasing
  • Temporary staffing
  • Supplier payment dates
  • Bank settlement timing
  • Refund levels
  • Gift-card liabilities
  • Cash-flow requirements

Our monthly bookkeeping process accounts for those trading patterns, rather than treating a quiet February and a busy December as though they create the same workload.

A Monthly Process Built for Retail Complexity

Every stage has a defined purpose, from the first systems review to the completed monthly report.

  1. 1

    Review

    We assess your stores, sales channels, payment methods, VAT position, software and current bookkeeping condition.

  2. 2

    Connect

    We establish access to the agreed bank feeds, sales reports, payment statements, invoices and payroll records.

  3. 3

    Reconcile

    We match sales, settlements, fees, refunds, supplier balances and control accounts, then flag missing evidence.

  4. 4

    Close

    We complete agreed journals, review the balance sheet and prepare the period for reporting or return work.

  5. 5

    Report

    You receive the agreed monthly reports together with a clear list of outstanding items requiring management action.

Bookkeeping That Goes Beyond Imported Transactions

The value lies in checking whether the systems agree, not simply moving data from one platform to another.

01

Retail-Specific Reconciliation

We account for cash, card settlements, marketplace payouts, merchant fees, returns and timing differences within one controlled process.

02

UK Compliance Language

Your records are organised around HMRC, VAT, PAYE, National Insurance and Making Tax Digital rather than irrelevant federal or state terminology.

03

Channel-Level Clarity

Where your systems allow it, we structure reporting by shop, department, platform or sales channel so performance is easier to compare.

04

Documented Month-End Checks

Bank accounts, payment clearing accounts, VAT balances, supplier ledgers and other agreed controls are reviewed before the period is treated as complete.

05

Compatible Software Workflows

We can assess accounting, POS, ecommerce and payment systems such as Xero, QuickBooks, Shopify, Amazon, Square, Stripe and PayPal, subject to agreed integrations and access.

06

One Named Point of Contact

Your queries, missing-document requests and reporting questions are managed through an agreed contact rather than scattered across an unknown support queue.

Retail Bookkeeping Standards

  • ✔ Gross sales recorded before fees
  • ✔ Settlements matched to bank receipts
  • ✔ Refunds posted to the correct period
  • ✔ Supplier credits allocated properly
  • ✔ VAT control balance reviewed
  • ✔ Stock journals supported by reports
  • ✔ Payroll journals matched to payroll records
  • ✔ Reconciliation differences documented

Bookkeeping That Goes Beyond Imported Transactions

The value lies in checking whether the systems agree, not simply moving data from one platform to another.

01

Retail-Specific Reconciliation

We account for cash, card settlements, marketplace payouts, merchant fees, returns and timing differences within one controlled process.

02

UK Compliance Language

Your records are organised around HMRC, VAT, PAYE, National Insurance and Making Tax Digital rather than irrelevant federal or state terminology.

03

Channel-Level Clarity

Where your systems allow it, we structure reporting by shop, department, platform or sales channel so performance is easier to compare.

04

Documented Month-End Checks

Bank accounts, payment clearing accounts, VAT balances, supplier ledgers and other agreed controls are reviewed before the period is treated as complete.

05

Compatible Software Workflows

We can assess accounting, POS, ecommerce and payment systems such as Xero, QuickBooks, Shopify, Amazon, Square, Stripe and PayPal, subject to agreed integrations and access.

06

One Named Point of Contact

Your queries, missing-document requests and reporting questions are managed through an agreed contact rather than scattered across an unknown support queue.

Retail Bookkeeping Standards

  • ✔ Gross sales recorded before fees
  • ✔ Settlements matched to bank receipts
  • ✔ Refunds posted to the correct period
  • ✔ Supplier credits allocated properly
  • ✔ VAT control balance reviewed
  • ✔ Stock journals supported by reports
  • ✔ Payroll journals matched to payroll records
  • ✔ Reconciliation differences documented

Retail Figures That Make Accurate Books More Valuable

Recent UK data shows why retailers need timely information about sales, costs and seasonal performance.

Indicator Latest Reported Figure Meaning for Retailers
Great Britain retail sales volume, June 2026 Up 1.0% month-on-month Growing sales activity increases the need for timely reconciliation.
Quarter 2 retail sales volume Up 0.6% from Quarter 1 Period comparisons require consistent monthly coding.
June 2026 annual sales volume Up 4.2% from June 2025 Higher turnover can conceal margin pressure if fees and stock costs are unclear.
Non-store retail sales, May 2026 Up 6.1% month-on-month Online-channel growth creates more platform and settlement data.
Independent retailers reporting weaker Q4 trade 56.47% Sales totals alone do not reveal whether a retailer’s position is improving.
Median Q4 decline reported by surveyed independents 8% Fast access to margin and cash information supports earlier decisions.
VAT-registered businesses under MTD for VAT All must keep relevant digital records Compatible software and organised digital records are essential.
2026 MTD Income Tax starting threshold Over £50,000 qualifying income Affected sole traders need suitable digital records and software.

ONS reported that Great Britain retail sales volumes rose by 1.0% in June 2026 and by 0.6% across Quarter 2, with June volumes 4.2% above June 2025.

In May 2026, non-store retail sales volumes rose by 6.1% month-on-month, illustrating the continued importance of ecommerce and remote-selling records.

A British Independent Retailers Association survey reported that 56.47% of respondents experienced worse Q4 trading than the previous year, with a median decline of 8%. The sample represents Bira respondents and should not be described as the whole UK retail market.

From 6 April 2026, Making Tax Digital for Income Tax applies to qualifying sole traders and landlords with annual qualifying income above £50,000.

Retail Bookkeeping Questions Answered

A bookkeeper keeps track of a business’s finances, keeping either a physical or digital record of all income and expenses. This is vital for tax purposes, as having a detailed record of all profits and losses for the year is invaluable. It is also important to manage viable data, revealing whether a business is making a profit or operating at a loss.

Yes, subject to system access and the agreed engagement. We can compare platform reports, payment statements and bank deposits to separate gross sales, fees, refunds and settlement timing differences. Where direct integrations are unavailable, structured exports may be used.

We can assess and support commonly used cloud accounting systems including Xero and QuickBooks. We first review the existing chart of accounts, bank feeds, integrations and transaction quality before confirming the best working method.

Not automatically. The key question is whether your present EPOS can provide reliable sales, VAT, payment-type, refund and product reports. We review the available exports and integrations before recommending any software change.

A cleanup project can be agreed before monthly work begins. This may include reconciling previous bank periods, correcting duplicate entries, reviewing opening balances, matching settlements and identifying transactions without adequate supporting records.

We can support the bookkeeping and accounting records connected with inventory, including stock journals, purchase coding, cost of goods sold and reconciliation to inventory reports. Physical stock counting, warehouse management and purchasing decisions are separate operational services unless specifically agreed.

We can maintain VAT-ready transaction records and reconcile relevant control accounts within the agreed scope. The responsibility for reviewing and submitting a VAT Return should be stated clearly in your engagement letter.

Yes. Where your systems and source records support it, accounts may be structured using tracking categories, departments, locations or separate clearing accounts. This can provide reporting by store, sales channel or operating unit.

Fees depend on monthly transaction volume, number of bank accounts, stores, payment processors, marketplaces, payroll size, VAT requirements, inventory complexity and the condition of existing records. A retailer with one shop and one payment provider will usually require a different scope from a multi-store omnichannel business.

Timing depends on access, record quality, the number of systems and whether previous periods require correction. After the initial review, we provide an onboarding list covering software access, bank feeds, sales reports, payment statements, invoices, payroll records and opening balances.

We provide accounting and bookkeeping services within the agreed engagement. Where a decision requires regulated investment, legal or specialist financial advice, you should consult a suitably authorised professional.

Make Every Sale Count in Your Monthly Figures

When you allow us to keep track of your finances, you give yourself more time to do your work and please more clients. It's a win-win situation for everyone. Aside from that, you'll also gain financial stability because your assets and liabilities are managed well enough not to cause any trouble for you in the future.

So let our experts work for you, and you won't regret it even a bit.

Book a call today to get started.

Don’t Let Accounting Issues Hold You Back Get Expert Help Today

Accounting problems can slow down your business. Let us handle your accounting needs and give you the freedom to focus on growth. Get expert help today—book your consultation now.

Yes, Let’s Get Started!
Thanks, I'll Be Back Later!