Payments

Here you will learn how to use the Payments input table.

Payments Walkthrough

Understanding Payments

The Payments sheet serves as the central hub, where all customer transactions are recorded and monitored. Almost all columns are filled automatically by our internal systems—please do not edit these. They include lead details, billing information, invoice data, opt-in timestamps, and UTM parameters.

We’ve filled this with sample data to help you understand how the view looks:

If you are unsure what a particular term means, check the Glossary of Variables for a full definition.

Glossary of Variables

Please note that all rows in Payments are automatically populated from transactions submitted via the Master Form. If you need to see that process step-by-step, refer to the tutorials linked on the Master Form page.

Master Form

How it Works

Now that you know what it looks like, the only parts that need your attention are the blue columns (Extra_Fees, Notes, Accounting_Check):

Now, let’s take a look at the purpose each one of them serves.

Column
Purpose
When to fill it

Extra_Fees

Log any unexpected charges that were not covered in the original payment (e.g., bank fees or currency-conversion costs).

As soon as the extra cost is identified.

Notes

Add clarifications or relevant context about the payment (objections, client requests, etc.).

Whenever extra explanation is useful.

Accounting_Check

Confirms whether the payment has been verified by accounting.

Update daily and only after the funds are confirmed received

Accounting_Check and Not_Filled

We have to understand something, the most crucial part of Payments is the "Accounting_check" because of

  1. Revenue tracking – ensures we know exactly what has been collected.

  2. Team payouts – prevent delays or discrepancies in commission calculations.

  3. Issue resolution - provides us with all the necessary supporting details to quickly resolve any payment problems.

And that’s why we have a validation system to check if everything is correctly filled—the column called "NOT_Filled."

At this point, you might be asking yourself:

How do Accounting_Check and NOT_Filled work together? So let’s answer that question clearly to leave no room for doubt…

Exists a clear correlation between these two and works like this:

  • Select “Yes” in Accounting_Check once the payment is confirmed.

    → The NOT_Filled column will automatically show “Good”.

  • Leave Accounting_Check blank if the payment is still pending verification.

    NOT_Filled will display “Error,” flagging the row for follow-up or indicating that the payment hasn’t arrived and something needs to be resolved with the lead.

  • Additionally, please note that if the payment originates from a Sales Call, we will verify whether the ID exists, allowing us to match it to the actual call. If the Call ID can't be found, the payment "NOT_filled" will display an "Error". Only after updating it with the correct Sales Call ID will it show "Good".

With that in mind, you now know how to use the "Payments" sheet and validate all registered payments. Thanks for reading!

Last updated