---
title: "Exact Online crate deposits per customer · Hypamoon"
description: "Keeping track of crates and kegs per customer in a spreadsheet? Get the balance per customer from what was delivered and taken back."
url: https://hypamoon.com/connect-to/exact-online/crate-deposits
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Exact Online](https://hypamoon.com/connect-to/exact-online)
3.  Crate deposits

For teams that run on Exact Online

# Exact Online crate deposits per customer

Drinks wholesalers and breweries put deposit crates and kegs on the invoice as items in Exact Online. How many each customer still has is counted outside it.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=exact-online/crate-deposits)

## How it goes today

1.  Look up the deposit items on each delivery.
2.  Subtract what the driver took back.
3.  Keep the balance per customer in a spreadsheet.
4.  Call customers when the numbers do not add up.

## How it can go

**You know how many crates and kegs each customer still has.**

From the deposit items delivered and taken back in Exact Online you get per customer the balance of crates, kegs and pallets, with the value. Each month customers you mark get their own statement.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. Exact Online works with a sign-in instead of a key: you sign in to Exact Online once to give access, never in the chat.

Your request

> With Hypamoon, using the deposit items for crates, kegs and pallets in Exact Online, keep per customer the balance of what was delivered minus what was taken back, with the deposit value. Show me the list with the largest balances first and each month email the customers I mark their own statement.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~exact-online/crate-deposits&say=a%20balance%20per%20customer%20of%20crates%2C%20kegs%20and%20pallets%20from%20the%20deposit%20items%20in%20Exact%20Online%2C%20with%20a%20monthly%20statement.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=exact-online/crate-deposits)

You register your own app in the App Center of your Exact Online environment and sign in once to give it access to your company. It stays yours.

## More for teams on Exact Online

-   [**I still type every line of every purchase invoice into Exact Online.**](https://hypamoon.com/connect-to/exact-online/purchase-invoice-lines)
-   [**I can only send one statement at a time from Exact Online.**](https://hypamoon.com/connect-to/exact-online/customer-statements)
-   [**I export from Exact Online twice and build a pivot table to see it per country.**](https://hypamoon.com/connect-to/exact-online/export-to-excel)
-   [**Exporting my own data from Exact Online does not work in one go.**](https://hypamoon.com/connect-to/exact-online/backup)
-   [**Every month I download a journal from our CRM and import it into Exact Online.**](https://hypamoon.com/connect-to/exact-online/import-invoices)
-   [**I book the whole credit card statement as one invoice.**](https://hypamoon.com/connect-to/exact-online/credit-card-statements)
-   [**I enter the exchange rates in Exact Online by hand every day.**](https://hypamoon.com/connect-to/exact-online/exchange-rates)
-   [**Each month I merge the figures of every company into one spreadsheet.**](https://hypamoon.com/connect-to/exact-online/consolidation)
-   [**Every month I run the same reports in Exact Online and mail them on.**](https://hypamoon.com/connect-to/exact-online/monthly-report)
-   [**I want to see days sales outstanding per country, but I can't filter on country everywhere.**](https://hypamoon.com/connect-to/exact-online/payment-behaviour)
-   [**I calculate the interest on each late invoice by hand.**](https://hypamoon.com/connect-to/exact-online/late-payment-interest)
-   [**Before the new year I write the new prices in Excel first.**](https://hypamoon.com/connect-to/exact-online/price-increase)
-   [**I change the price on every subscription by hand each year.**](https://hypamoon.com/connect-to/exact-online/subscription-prices)
-   [**I want to send a payment confirmation once a customer has paid.**](https://hypamoon.com/connect-to/exact-online/payment-confirmation)
-   [**I type every order between our two companies in twice.**](https://hypamoon.com/connect-to/exact-online/intercompany-orders)
-   [**Every new item has to be created again in each of our companies.**](https://hypamoon.com/connect-to/exact-online/master-data-sync)
-   [**Our engineers write hours in their own company, but the client gets the invoice from another one.**](https://hypamoon.com/connect-to/exact-online/intercompany-hours)
-   [**Each month end I work out our unbilled hours in a spreadsheet and book them by hand.**](https://hypamoon.com/connect-to/exact-online/work-in-progress)
-   [**After each delivery someone has to remember to make the invoice.**](https://hypamoon.com/connect-to/exact-online/invoice-deliveries)
-   [**Half the calls we get are customers asking where their order is.**](https://hypamoon.com/connect-to/exact-online/delivery-updates)
-   [**When a customer asks for their prices, I spend an hour in a spreadsheet.**](https://hypamoon.com/connect-to/exact-online/customer-price-list)
-   [**After a price change I go through every open order to fix the prices.**](https://hypamoon.com/connect-to/exact-online/reprice-open-orders)
-   [**Our warehouse fills in each CMR by hand from the packing slip.**](https://hypamoon.com/connect-to/exact-online/cmr-consignment-note)
-   [**I add our handling percentage to each invoice with a calculator.**](https://hypamoon.com/connect-to/exact-online/invoice-surcharges)
-   [**We put the costs of a container in a spreadsheet and divide by the number of boxes.**](https://hypamoon.com/connect-to/exact-online/landed-costs)
-   [**Twice a year we count on paper and then type it into Exact Online for two days.**](https://hypamoon.com/connect-to/exact-online/stock-count)
-   [**Our reorder points were set once and nobody has looked at them since.**](https://hypamoon.com/connect-to/exact-online/reorder-points)
-   [**Every month I hand my bookkeeper a stack of till receipts to type in.**](https://hypamoon.com/connect-to/exact-online/cash-book)
-   [**Every week I download the CODA files and upload them one by one.**](https://hypamoon.com/connect-to/exact-online/coda-bank-files)
-   [**Each new member means typing a mandate into Exact Online by hand.**](https://hypamoon.com/connect-to/exact-online/direct-debit-mandates)
-   [**We have nine kinds of membership, billed monthly, quarterly or yearly.**](https://hypamoon.com/connect-to/exact-online/membership-fees)
-   [**Our rentals live in a spreadsheet and I invoice them by hand each month.**](https://hypamoon.com/connect-to/exact-online/rental-invoicing)
-   [**Every Friday our office types in a stack of paper work orders.**](https://hypamoon.com/connect-to/exact-online/work-orders)
-   [**Each month I copy the payroll journal line by line into Exact Online.**](https://hypamoon.com/connect-to/exact-online/payroll-journal)
-   [**I add up our sales to consumers in other EU countries by hand each quarter.**](https://hypamoon.com/connect-to/exact-online/oss-threshold)
-   [**A big client wants our emissions and I have no idea where to start.**](https://hypamoon.com/connect-to/exact-online/carbon-from-spend)
-   [**I write almost the same hours every day: client, project, code, number.**](https://hypamoon.com/connect-to/exact-online/repeat-timesheets)
-   [**Customers tell us the invoice did not arrive.**](https://hypamoon.com/connect-to/exact-online/invoice-emails)
-   [**My bookkeeper keeps sending me lists of receipts they do not have.**](https://hypamoon.com/connect-to/exact-online/receipt-reminders)
-   [**Our payment schedule per project lives in a spreadsheet next to Exact Online.**](https://hypamoon.com/connect-to/exact-online/milestone-invoicing)
-   [**We retype item codes into the label program for every receipt.**](https://hypamoon.com/connect-to/exact-online/item-labels)
-   [**Everything for Exact Online**](https://hypamoon.com/connect-to/exact-online)
