Skip to main content

PennyWise

Calendly Book a Meeting
Email

info@pennywiseusa.com

Get the free template: a simple Excel spreadsheet (also works in Google Sheets) to track Amazon settlements, check them against your bank deposits, record inventory and cost of goods sold, and see a monthly profit and loss. Enter your name and email below and we’ll show you the download link and email it to you.

    We’ll email you the link too. No spam; unsubscribe any time.

    What’s inside

    • Settlements tab: one row per settlement with product sales, shipping credits, promotions, refunds, referral fees, FBA fees, storage, advertising, other fees, reimbursements, sales tax and reserves. It calculates the net settlement and flags any difference from your bank deposit.
    • Inventory & COGS tab: units purchased, unit cost, freight and duties, landed cost per unit, units sold and cost of goods sold.
    • Monthly P&L tab: net sales, gross profit, Amazon fees, advertising, reimbursements, profit, plus gross margin, fees % and advertising % of sales, and two built-in checks.
    • How-to tab: short instructions and an example row.

    How to use it each month

    1. Download each settlement from Seller Central (Payments, All statements) and enter its totals in a new row, with fees and refunds as negative numbers.
    2. Enter what actually reached your bank. The Difference column should show zero.
    3. Update the inventory tab with new purchases and units sold.
    4. Read your Monthly P&L. Check that sales tax nets to zero (Amazon collects and remits it; see why settlements cross month-end and our guide to recording settlements).

    When a spreadsheet stops being enough

    A spreadsheet works while you’re small. Once you have several settlements a month, multiple marketplaces or Shopify too, it gets slow and error-prone, and settlements that cross month-end make monthly profit inaccurate. That’s when sellers move to QuickBooks Online with A2X. See how to set up A2X with QuickBooks Online, or let us run it for you.

    Want this done for you?

    PennyWise is an A2X Certified, QuickBooks ProAdvisor bookkeeping team for US sellers. We reconcile every settlement, record cost of goods sold and send your P&L by the 10th of each month. See our Amazon FBA bookkeeping service or start with a free QuickBooks Health Check.

    Leave a Reply

    Your email address will not be published. Required fields are marked *