Payments are in any company. And when the business is gaining momentum, there are more of them, as well as the problems associated with them. If you are having financial difficulties, you can always contact Payday Depot and they will help you. We tell you how to put things in order in payments using a single form. With it, you can collect payment documents in one place, and then quickly transfer them to the payment register and calculate the payment calendar. All you need is good Excel skills, knowledge of a few “secret” formulas, a sequence of steps, and patience.
How to create a form
To begin with, you need a budget classifier: a separate one for receipts, and a separate one for the company’s expenditure payments. The budget classifier is a constant. It will link all forms of control and planning of funds. If there is no budget classifier yet, it can be assembled from a standard set of articles. Even 5 is enough – even if they are not perfect and do not take into account everything, but start with them. The rest will be clarified in the process. Example names: wages, taxes, communications and the Internet, rent, etc.
Registration of documents for payment
All received documents for payment and payment schedules are regularly registered here. This is a guarantee of order and a guarantee that nothing will be lost and everything will be paid for on time. Yes, the first half of the information will have to be filled in manually as payment documents appear. You can then transfer unpaid and monthly payments from the previous period, and new payments as documents are received.
Tekedia Mini-MBA edition 16 (Feb 10 – May 3, 2025) opens registrations; register today for early bird discounts.
Tekedia AI in Business Masterclass opens registrations here.
Join Tekedia Capital Syndicate and invest in Africa’s finest startups here.
Registration of documents for receipts
It can be filled out in the same way as the expense payment form. For example, download all outstanding invoices and/or scheduled payments. Then leave only those that, under the terms of the contracts, will be paid in the reporting month. Benefit: You will have a detailed breakdown of expected receipts, but many daily adjustments are possible after the fact. This option is suitable for a stable income or a small amount.
When it is difficult to plan receipts for specific dates, it is easier to download a fact from the statement daily. Don’t try to fill in all the columns. Advantage: high speed and ease of information processing, but you will not have a transcript of the expected receipts. And it is important for the payment calendar. This issue will need to be worked out separately later.
Payment schedule
In part, this function is already performed by the BDDS of the month, if it is updated and planned under contracts. Partially it is performed by all registered payments. After all, the payment date is planned according to the terms of the contract or payment schedule with a margin of days without the risk of overdue debts. The function of the payment calendar is also performed by the register of payments, when you see the actual balance at the beginning of the day, the expected income – and adjust the payment plan.
