← Back to blog

Item Mapping in QuickBooks for Marinas: Setup Guide

November 15, 2026
Item Mapping in QuickBooks for Marinas: Setup Guide

Item mapping is the rule that tells your marina software which QuickBooks Online product or service item each charge belongs to, so a slip rental, a fuel ticket or a ship store sale lands in the right income account without anyone retyping it. Get the item list right once, map every charge type to it, and your books stay clean as volume grows. Atlantis Marina syncs with QuickBooks Online so revenue is billed, collected and booked without manual entry, and the work below is what makes that sync accurate from the first invoice.

Atlantis Marina
Keep Marina Billing Connected
Atlantis Marina syncs billing with QuickBooks Online, helping marina teams manage revenue in one cloud-based operations platform.
See what Atlantis Marina can do for you!

TL;DR

  • An item is the bridge: each QuickBooks product or service item is assigned an income account, and every sale posted with that item feeds that account.
  • Build items around how you want to report (slips, storage, fuel, utilities, retail, fees), then map each marina charge type to exactly one item.
  • Changing an item's income account later is simple, but whether past transactions change depends on the item type, so decide before you go live.
  • Check the first week of synced invoices line by line against your item list, then reconcile.
  • Most sync problems come from missing, renamed or duplicate items, and they are fixed at the item list, not in the invoice.

Table of Contents

What item mapping means for a marina

QuickBooks Online records what you sell through products and services items. Each item is assigned an income account, and sales posted with that item increase that income category. You review them under All apps > Sales & Get Paid > Products & services.

A marina has far more kinds of revenue than a typical small business. A single boater account can generate seasonal slip rent, a transient night, electric metering, a haul-out, a lift launch, a pump-out, a bottle of oil from the ship store and a late fee in the same month. Mapping decides where each of those goes:

  1. Your marina software creates a charge (a reservation, a fuel ticket, a POS sale, an adjustment).
  2. The charge carries a type that is matched to a QuickBooks item.
  3. The item points to an income account, and the invoice line posts there.

If step 2 is loose, everything lands in one catch-all account. Your profit and loss shows one big revenue number, and you cannot tell whether dockage or the fuel dock is carrying the year. If step 2 is tight, the P&L reads like the marina actually runs.

Items versus accounts

The income account is where money is categorized. The item is the line on the invoice. Several items can point to the same income account, so you can keep detailed reporting by item (say, transient dockage and seasonal dockage) while both roll up into a single Dockage Income account. That flexibility is why mapping to items is the better design for a marina than mapping every charge straight to an account.

Which marina charges need their own item

Start from the questions you want your books to answer. Typical ones for a marina owner or dockmaster:

  • How much did we earn from seasonal versus transient slips?
  • What is our fuel margin, separate from the store?
  • Are electric and water pass-through costs covered by what we bill?
  • How much comes from dry stack storage and launches versus wet slips?
  • How much are we collecting in late fees and service charges?

A workable starting list looks like this:

Charge typeSuggested itemIncome account
Seasonal slip rentDockage:SeasonalDockage Income
Transient and nightly staysDockage:TransientDockage Income
Dry stack storageStorage:Dry StackStorage Income
Boat lift and launchServices:Lift and LaunchService Income
Metered electric and waterUtilities:MeteredUtility Income
Fuel salesFuel:Gas and DieselFuel Income
Ship store merchandiseRetail:Ship StoreRetail Income
Service and repair laborServices:LaborService Income
Late fees and adjustmentsFees:Late FeeFee Income

Treat this as a template, not a rule. Your accountant may want separate income accounts for fuel and retail because of how cost of goods sold is tracked, and that is a decision for them and your chart of accounts.

Use a clear naming pattern

QuickBooks Online supports a hierarchy, and its import format uses category:sub-category:product or service. Use it. Names like "Dockage:Seasonal" sort together, are easy to scan in a dropdown, and make duplicates obvious. Agree on one convention (singular, no abbreviations that vary by person) and keep it.

Keep items at the right level of detail

Do not create an item for every slip or every vessel. Items describe the kind of revenue, not the customer. The customer, the slip and the vessel stay on the marina side, in the vessel records and facility maps. Over-granular lists are the most common reason mappings drift.

How to set up item mapping, step by step

Step 1: Build or clean the item list in QuickBooks Online

To add an item, open All apps > Sales & Get Paid > Products & services, select New product/service, choose Non-inventory item or Service, and enter a name and optional SKU. Most marina charges are services. Fuel and ship store goods may be non-inventory or inventory depending on how you track stock, which is worth settling with your bookkeeper first.

Where it goes wrong: copying an old list that holds retired items, near-duplicates ("Electric" and "Electricity") and items pointing at the wrong account. Inactivate what you do not use before mapping anything.

If you already have a long list in a spreadsheet, you can load it in bulk. Settings > Import Data > Products and Services lets you map spreadsheet columns to QuickBooks fields and fix rows flagged with red errors. One caution from QuickBooks: overwriting existing item details cannot be undone, so export or back up the list before importing over existing items.

Step 1: Build or clean the item list in QuickBooks Online

Step 2: Confirm each item's income account

Open each item and check the income account. To change it, go to Settings > Products and services, select Edit, choose the Income account and select Save and close. The account needs the Sales of Product Income detail type. Do this review once, with your chart of accounts open next to it.

Step 3: Decide how history should behave

This is the step people skip. QuickBooks explains that for service and non-inventory items, an option to also update the account in historical transactions can change prior transactions. For inventory items, if you do not want the historical effect, create a new item with the correct income account instead.

For a marina, this matters at season boundaries. If you re-point an item in the middle of a closed fiscal year and tick the historical option, you rewrite revenue categories your accountant may already have filed. Change mappings at the start of a period, or ask your accountant before touching closed months.

Step 3: Decide how history should behave

Step 4: Map every marina charge type to one item

Now connect the marina side. List each charge type your software can generate, and pair it with exactly one QuickBooks item. Include the ones that are easy to forget:

  • Refunds and adjustments, which need to reverse against the same item as the original charge.
  • Fees tied to online payments.
  • Deposits and prepayments on reservations.
  • Sales tax lines, if you collect tax on retail or fuel.
  • Add-on revenue such as dry stack launches, fuel dock tickets and metered utilities.

Atlantis Marina covers these in one platform: slip assignments, reservations, dry storage and launch queues, ship store POS, fuel and utility billing, refunds and adjustments, and QuickBooks Online sync. Because charges originate from one system, you map the charge types once instead of keeping a separate rule for each tool. See how the pieces fit on the marina management solution page, and how retail and fuel sales are rung up on the ship store POS and fuel and utility billing pages.

Step 5: Run a test cycle before go-live

Create a handful of realistic charges: a seasonal slip invoice, a transient stay, a fuel ticket, a store sale with a refund, a late fee. Sync them and look at each in QuickBooks. For every invoice line, ask three questions: is the item right, is the income account right, is the amount right? Fix the mapping, not the invoice, so the same mistake does not return next week.

How to check that synced charges land correctly

A mapping that looked right on day one can drift when someone adds an item or renames a service. Build a short routine:

  1. Weekly during the first month: open the Sales by Product/Service report in QuickBooks and compare it to what your marina software shows for the same dates. Totals by category should match.
  2. Look for the catch-all: any revenue sitting in a generic or uncategorized account means a charge type has no item.
  3. Spot-check refunds: a refund should reduce the same income line as the original sale.
  4. Reconcile the deposits: payment processor payouts, ACH and card batches need to tie to your bank. The walkthrough in How to Reconcile QuickBooks Online After a Marina Sync shows the order to work in, and Undeposited Funds in QuickBooks for Marinas explains why payments can sit there until they are matched.

A worked example: in a month your marina bills $48,000 across seasonal dockage, $6,500 in fuel and $3,200 in store sales. Sales by Product/Service shows dockage correct, but fuel at $9,700 and store at zero. The store sales are being posted to the fuel item. You do not edit invoices; you open the store charge type, point it at the Retail item, and re-check next week's report.

Troubleshooting missing, mismatched and duplicate items

Most problems trace back to the item list. Use this table as a first pass.

SymptomLikely causeFix
A charge fails to syncThe mapped item was deleted, inactivated or renamedRestore or recreate the item and re-map the charge type
Revenue in the wrong accountItem points to the wrong income accountEdit the item's income account, mindful of the historical option
Two similar items appearItems created by hand with slightly different namesChoose one, inactivate the other, update the mapping
Old reports changed after a fixHistorical update option was tickedReview with your accountant; use a new item when you need a clean break
Totals differ from the marina reportRefunds, discounts or fees without their own itemAdd the missing items and map them

For deeper diagnosis of failed syncs, QuickBooks Online Sync Errors: Causes and Fixes for Marinas goes through the error patterns marina teams run into. If a single boater shows up as two customers, the issue is account matching rather than items, and Customer Account Linking for Marinas covers how unified billing keeps one account per customer.

Prevent drift

  • Give one person ownership of the item list.
  • Add new items in QuickBooks first, then map the charge type, never the other way round.
  • Review the list at the start of each season, when you add new services and retire old ones.
  • Keep the list short. Fewer, well-named items beat dozens of near-copies.

Mapping for dry stack, fuel and smart equipment

Marinas with more than slips have more revenue streams to map, and they deserve their own items from the start.

  • Dry stack: storage, launches and retrievals are different revenue, so give them separate items under a Storage or Services parent. The dry stack marina software page shows how queues and storage are managed.
  • Fuel and utilities: fuel tickets and metered electric or water are billed on different logic, so keep them apart. Mixing them hides whether your utility billing covers what you pay.
  • Lift automation and cameras: if you offer connected lift or camera services to members, treat them as their own revenue lines if you bill for them.
  • Inventory: if the ship store holds stock, how items are set up affects your counts. Stop Weekly Reconciles: Marina Inventory Management for Operators covers keeping stock and books in line.

Why mapping is easier from one platform

The more systems that create charges, the more mapping tables you maintain. A reservation tool, a separate POS, a fuel dock spreadsheet and a payment portal each need their own rules, and each can drift on its own schedule. One platform that handles reservations, billing, POS, payments and sync lets you define the mapping in one place and audit it in one place.

What we see in a marina's books

We built Atlantis Marina so that the charge, the payment and the accounting entry come from the same system. When a boater pays through autopay or an Instant Pay link, using Stripe or ACH processing, the platform's job is to keep revenue billed, collected and booked without manual entry. Item mapping is the part that makes that promise accurate.

Our advice is to treat the item list as a reporting design, not as a chore. Decide what you want to know about dockage, storage, fuel, retail and services, build items that answer it, and map each charge type once. A marina that does this can read its profit and loss like a dashboard instead of a puzzle.

Because the same account follows a boater from reservation to invoice to payment, you map the charge types one time and every customer benefits from it.

John R

Put it to work with Atlantis Marina

If you are tired of re-keying marina revenue into QuickBooks, Atlantis Marina connects slips, reservations, dry stack, fuel, ship store POS, billing and QuickBooks Online sync in one cloud platform. Plans are priced by marina size, from Micro at $150 per month to Large at $900 per month, with Small at $300 and Medium at $500, and Enterprise available on request. Atlantis setup is a one-off $100 to $1,000. Dry-stack operations add-on runs $79 to $299 per month, and automated fuel operations is $50 per month. See the full list on the pricing page.

Atlantis Marina

To see how your charge types would map, start from the Atlantis Marina home page and choose the product line that fits your facility.

FAQ

What is item mapping in QuickBooks for a marina?

It is the link between a type of marina charge, such as seasonal dockage or a fuel sale, and a QuickBooks Online product or service item. Each item is tied to an income account, so synced sales post to the right revenue category automatically.

Should I map to items or directly to income accounts?

Map to items. Several items can roll up into one income account, so you keep detailed reporting by item and a simple chart of accounts. Direct account mapping gives you less detail on the same revenue.

Can I change an item's income account after I go live?

Yes. In QuickBooks Online, edit the item under Products and services and choose a new income account. For service and non-inventory items you can choose whether to update past transactions too, so confirm the effect with your accountant, particularly for closed periods.

Why did a marina charge not sync to QuickBooks?

The usual cause is an item that was deleted, inactivated or renamed, or a charge type with no item assigned. Restore or recreate the item, map the charge type to it, and sync again. Our guide to sync errors lists other common causes.

Sources