October 5, 2026

How to read the ClubGG club export: what every sheet means and three checks that catch lost data

The club report from ClubGG is the only full record of what happened in your club: who played, how much rake came in, who got chips and who gave them back. It arrives as one Excel file with a dozen sheets. Here is what each of them means, how to check that nothing is missing, and the mistakes that quietly break the books.

We process this file every day for a live club and have read every row of more than eighty of them. Everything below comes from that work, not from the help pages.

Before you open it: how the report is made

It covers at most 7 days, and only the last 30. Anything older is gone for good. If you want history, you have to keep the files yourself.
It costs diamonds. Every export is paid in the app's currency, so re-exporting "just to check" is not free.
The sheets you do not tick do not arrive. When you request the report, two checkboxes matter most: Trade Record and Club Member Balance. Without them you get the games but not the chips, and the debts cannot be counted.
Times are in one time zone, printed at the top of each sheet, for example UTC +2:00. Keep everything you record by hand in the same zone, or the same deal will look like two different deals an hour apart.

What each sheet means

Ring Game Statistics

One row per table. Game type (NLH, PLO5, PLO6), blinds, hands, players, total rake and the jackpot fee. This is ClubGG's own total, and it is your control figure.

Ring Game Detail

One row per player per table: hands, rake paid, profit or loss. Rakeback is calculated from here. A table that runs past midnight is split into two blocks, one per calendar day, so the same table appears twice and has to be added up.

Trade Record

Every chip movement between the club and a member. Negative amounts are chips sent out (a buy-in on credit, a payout in chips), positive amounts are chips taken back. Each row also shows the club's chip balance before and after the deal.

Club Member Balance

A snapshot of every member's chips at the moment the report was made, with their role (Player, Agent, Manager) and their agent. For agents there are two numbers: Chips, their own, and Credits, the pool they have not yet handed out.

Member Statistics, Overview

Summaries for a quick look. Useful for a glance, not for the books.

SNG, Spin&Gold, MTT

The same structure for tournaments. Empty if your club only runs cash games.

Two things the export does not show

Player to player transfers do not exist as such. When a manager moves chips from one player to another, the export shows two separate deals: chips taken from the first player and chips sent to the second, a few seconds apart. If you also wrote the transfer down by hand, count it once, not three times.
An agent handing chips to his own players is invisible. The pool leaves the club as one deal to the agent. What happens inside his group you only see in the balances, never as separate rows.

Three checks that catch lost data

The file is large and the mistakes in it are quiet. These three checks take seconds once they are automated, and each of them has caught a real loss for us.

1. Every table adds up to zero

What the players lost went to the winners, the rake and the jackpot fund. Nothing else. For every closed table:

sum of player results + rake + jackpot fee = 0

If a table does not add up, a player's row is missing. We once lost a row because a player's ID happened to start with "20" and was mistaken for a date. The table was off by exactly that player's result.

2. Detail matches Statistics

Add up the rake and the number of players from Ring Game Detail for each table and compare them with the same table in Ring Game Statistics. Allow a few cents for rounding, nothing more. If Detail is short, data was lost on the way to your sheet, not in ClubGG.

3. The chip balance continues from the last report

Trade Record shows the club's chip balance before and after every deal, as one running line. So the first deal of a new report must start exactly where the last deal of the previous report ended:

"before" of the first new deal = "after" of the last known deal

If it does not, deals are missing between the two files. This is the most expensive mistake on the list. In our case the next report was requested starting from the next day, while the previous one had been made in the afternoon. One evening of deals fell into the gap, and the books were off by over two thousand dollars until we re-exported that day.

Traps that break the books without an error

Start each report on the day of the previous one, not the day after. A report made at 2 pm does not contain the evening. Overlap is harmless if you skip deals you already have. A gap is not.
A session belongs to the day it started. A table opened at 11 pm and closed at 3 am is yesterday's game. A table that ran for a full day ends in the evening and will land on the wrong day if you go by the closing time.
Members who left disappear from Club Member Balance. If you only update the chips of members who are in the file, a player who left keeps his old chip count in your books forever. Someone who is not in the list has zero chips, and you should know what happened to them.
Never type in a chip movement that the export will bring. A hand-written row has its own time and will not merge with the real one. The debt gets counted twice.
Fix money records by adding, not by editing. A wrong entry gets cancelled by a mirror entry, and both stay visible. Once past entries start changing quietly, nobody trusts the numbers any more.

From the file to who owes what

With the checks passed, a player's position comes down to three numbers:

debt = chips sent to him minus chips taken back, minus money he paid in, plus money paid out to him;
chips in hand = his line in Club Member Balance;
rakeback = his rake from Ring Game Detail times his rate.

Settling up is then simple: debt minus chips minus rakeback. A positive result is what he owes the club, a negative one is what the club owes him. For agents the same logic runs one level up, across all of their players.

Let the file read itself

EasyRake takes the ClubGG report straight from your email, runs all three checks, and shows debts, chips, rakeback and the cage on your phone half a second later. It has been running in a live club since June.

See how it works →