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.
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
- Which marina charges need their own item
- How to set up item mapping, step by step
- How to check that synced charges land correctly
- Troubleshooting missing, mismatched and duplicate items
- Mapping for dry stack, fuel and smart equipment
- Why mapping is easier from one platform
- Put it to work with Atlantis Marina
- FAQ
- Sources
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:
- Your marina software creates a charge (a reservation, a fuel ticket, a POS sale, an adjustment).
- The charge carries a type that is matched to a QuickBooks item.
- 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 type | Suggested item | Income account |
|---|---|---|
| Seasonal slip rent | Dockage:Seasonal | Dockage Income |
| Transient and nightly stays | Dockage:Transient | Dockage Income |
| Dry stack storage | Storage:Dry Stack | Storage Income |
| Boat lift and launch | Services:Lift and Launch | Service Income |
| Metered electric and water | Utilities:Metered | Utility Income |
| Fuel sales | Fuel:Gas and Diesel | Fuel Income |
| Ship store merchandise | Retail:Ship Store | Retail Income |
| Service and repair labor | Services:Labor | Service Income |
| Late fees and adjustments | Fees:Late Fee | Fee 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 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 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:
- 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.
- Look for the catch-all: any revenue sitting in a generic or uncategorized account means a charge type has no item.
- Spot-check refunds: a refund should reduce the same income line as the original sale.
- 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.
| Symptom | Likely cause | Fix |
|---|---|---|
| A charge fails to sync | The mapped item was deleted, inactivated or renamed | Restore or recreate the item and re-map the charge type |
| Revenue in the wrong account | Item points to the wrong income account | Edit the item's income account, mindful of the historical option |
| Two similar items appear | Items created by hand with slightly different names | Choose one, inactivate the other, update the mapping |
| Old reports changed after a fix | Historical update option was ticked | Review with your accountant; use a new item when you need a clean break |
| Totals differ from the marina report | Refunds, discounts or fees without their own item | Add 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.

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
- Categorize sales transactions in QuickBooks Online
- Import products and services into QuickBooks Online
- Import products and services, mapping and overwrite details
- Change the account for a product or service item
- Add product and service items
