Skip to main content

Map Revenue Categories and GL Codes

Map Dockwa revenue categories and items to your G/L codes in Settings → Accounting or in your accounting integration's mapping tabs.

Map your Dockwa revenue categories and items to your general ledger (G/L) codes so your reports and accounting sync use your own account names. Where you map depends on whether you use a Dockwa accounting integration: without one, use Settings → Accounting; with one, use the mapping tabs in your integration under Marketplace.

  • Who can do this: Admin, Finance

  • Where: Account → Settings → Accounting (no integration), or Marketplace → your accounting integration (with an integration)

  • Before you start: Have your chart of accounts ready. If you use an integration, connect it first.

How do I map G/L codes without an accounting integration?

  1. Go to Account → Settings → Accounting. The page is titled G/L Mapping.

  2. Click Manage G/L Codes, then Add code for each G/L code you need. Click Save, then Back to G/L Mapping.

  3. Choose a tab: Accounting Fields, Items, Other, POS Items, or Boat Storage.

  4. For each Dockwa field, choose a code in the External field column. Leave No mapping to keep the Dockwa default.

  5. Click Save on each tab.

Your mapped names replace the Dockwa standard names in your Accounting Reports.

How do I map accounts with an accounting integration?

If your marina is eligible for an accounting integration, the Settings → Accounting page shows a note directing you to the Marketplace tab. Map there instead:

  1. Go to Marketplace and click Go to integration → on your accounting system.

  2. On Setup, choose your accounting basis and complete any required fields, such as the customer and discount item for QuickBooks Online.

  3. On Item Mapping, match each Dockwa item to a product in your accounting system. Child items inherit their parent item's mapping.

  4. On Revenue Mapping, map each revenue recognition category to an account.

Older integrations show Manage, Mapping, and Export tabs instead of Item Mapping, Revenue Mapping, and Sync Details.

Which revenue categories do I map?

Category

What it holds

Typical account type

Unearned Revenue

Invoiced amounts before the service period starts

Deferred or unearned revenue (liability)

Dockwa-processed Payment Receipts

Card and online ACH payments processed by Dockwa

Clearing or operating account (asset)

Processing Fees

Fees deducted before payouts

Merchant fees (expense)

Cash Receipts

Cash payments recorded in Dockwa

Operating account (asset)

Check Receipts

Check payments recorded in Dockwa

Operating account (asset)

Offline ACH Receipts

ACH payments recorded manually

Operating account (asset)

External Transactions

Payments marked as external (not processed by Dockwa)

As your accountant directs

For QuickBooks Online, map Accounts Receivable to the same account QuickBooks uses as its default A/R; refunds post there and won't sync until it's set. Deposit Liability and Tax Liability are used only in reports. Dockwa uses your default sales tax account, and deposits follow the mapping of your deposit item.

What happens if I don't map something?

In reports, unmapped items use the Dockwa category. With an integration, an empty required field on Revenue Mapping holds the document with code sync-010, and an unmapped item, discount, or sales tax item causes a sync failure (code item-001) until you map it and click Retry.

Does changing a mapping change past reports?

Reports use your mappings at the time you run them, so rerunning an old period after a change groups items under the new names. Synced records that already reached your accounting system are not re-sent. A new mapping applies the next time a document syncs, such as a new document, an update to an existing one, or a retry.

Related articles

Did this answer your question?