---
title: "Formitable bookkeeping export of online sales · Hypamoon"
description: "Sorting Formitable deposits, gift vouchers and takeaway for the books by hand? Get a monthly sheet per type, with the VAT you set, for your bookkeeper."
url: https://hypamoon.com/connect-to/formitable/online-sales
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Formitable](https://hypamoon.com/connect-to/formitable)
3.  Bookkeeping export

For teams that run on Formitable

# Formitable bookkeeping export of online sales

Deposits, prepaid tickets, gift vouchers and takeaway are paid online through Formitable. The help pages explain where each export lives and that gift vouchers are matched with the payouts of your payment provider by hand. The final VAT on a deposit comes from your till, which leaves the bookkeeper sorting several files each month.

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

## How it goes today

1.  Export the orders and the gift vouchers from Insights.
2.  Split deposits, gift vouchers and takeaway into separate columns.
3.  Match each line with a payout from the payment provider.
4.  Send the sheet to the bookkeeper and answer the questions that come back.

## How it can go

**Each month your bookkeeper gets the online sales from Formitable, sorted and totalled.**

On the first of the month the paid orders from Formitable arrive in one sheet: deposits and tickets, gift vouchers and takeaway on separate tabs, with order number, date, guest, amount and the VAT rate you set on each takeaway product. Canceled and failed orders are listed apart. Deposits are marked as paid in advance, so the bookkeeper knows their final VAT comes from the till. The sheet goes to your bookkeeper with the totals per type.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Formitable key in the portal, never in the chat.

Your request

> With Hypamoon, on the first of each month, take last month's paid orders from Formitable and make one sheet with separate tabs for deposits and tickets, gift vouchers and takeaway: order number, date, guest name, amount and the VAT rate per takeaway product. List canceled and failed orders apart. Mark deposits as paid in advance, with a note that their final VAT comes from the till. Email the sheet with the totals per type to our bookkeeper.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~formitable/online-sales&say=a%20monthly%20sheet%20of%20Formitable%20deposits%2C%20gift%20vouchers%20and%20takeaway%20with%20totals%20per%20type%2C%20sent%20to%20our%20bookkeeper.)

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

A Formitable administrator opens Settings, Team, turns on API user for an admin account, presses Get API key and chooses which data it may use. The restaurant key is under Settings, Widgets. It stays yours.

## More for teams on Formitable

-   [**We read the feedback in Formitable, but answering each guest rarely happens.**](https://hypamoon.com/connect-to/formitable/review-follow-up)
-   [**Before service someone reads every booking and writes the allergies on a note for the kitchen.**](https://hypamoon.com/connect-to/formitable/service-briefing)
-   [**Before each mailing we merge two Formitable exports to get our subscriber list.**](https://hypamoon.com/connect-to/formitable/newsletter-list)
-   [**We know our regulars by face, but in Formitable they look like any other booking.**](https://hypamoon.com/connect-to/formitable/regular-guests)
-   [**Before I make the rota I click through Formitable day by day to see how busy it gets.**](https://hypamoon.com/connect-to/formitable/covers-forecast)
-   [**Options for groups expire at different times and we lose track of who still needs a call.**](https://hypamoon.com/connect-to/formitable/open-options)
-   [**Everything for Formitable**](https://hypamoon.com/connect-to/formitable)
