How to track receipts on credit cards

2
10141
how to handle receipt of credit cards
Excel Spreadsheets

In this article we will talk about:

Is it worth having receipts on cards?

More and more we have seen more consumers walking around with little money in their pockets and using credit cards for necessary eventualities. This movement has been growing stronger with increased security for online purchase procedures, integration of applications / systems with multiple card banners, and the ease of high-value shopping installments.

banner credit card control worksheet

That is, if you have a business or are from a financial area, you are probably losing sales and money if you do not give the option of paying by credit card to your customers. So keep reading this post as I will tell you what are the best ways to implement this practice in your business right now.

Excel Spreadsheets

Register your types of receipts

I will not go to the trouble if you have a contract to receive directly with your bank, with payment gateways (such as Moip, Paypal or Pagseguro) or otherwise. Basically each of these payment processing solutions providers will have advantages and disadvantages and the most important at the first moment is to understand what the fee they charge you for each transaction.

If you have already done a search and found out what are your best options, it's time to register and fee administration fee for each type of use, per banner directly on your card receipt control worksheet:

how to control receipt of credit cards - card registration

There are 4 main types of use of receipts which are:

  • Debit
  • Credit
  • Short Term Installment Credit
  • Long-Term Installment Credit

For each of these, the company you hire may charge you a different rate and usually the longer the delivery period (quantity of parcels), the higher the amount you will have to pay.

Registration of receipts on credit cards

Now that we understand what we need to do before we start selling, we'll see how to record your receipts on credit cards.

When making your sales, make the proper records of your sales postings with the use of cards. The most important data to register are:

  • Date of sale
  • Value of the sale
  • Used flag
  • Type of use
  • Number of installments

With this information, a good tool (like our credit card control worksheet) already provides you with information such as:

  • Administrative fee
  • Net value received
  • Amount received in installments
  • Expected date of the first installment

See below:

How to Track Credit Card Receipt - Sales Launch

In this first view, with all your receipts, it can be difficult to draw conclusions and that is why it is necessary to organize all your payment forecasts in one place, where you can see the total of launches to be received per month as well such as the month-to-month record of these entries:

how to track receipt of credit cards - monthly payments forecast

With this information in hand, you already have a very good view of what you have to receive and can make comparisons with your accounts payable or amounts that are usually spent every month to see if you will need cash or not.

Card Banner Analysis

Another analysis that can help you a lot is to have the visualization of each of the flags that you use in your day to day. That way, you can track your statements and know if everything you were meant to enter is really coming in.

In our credit card control worksheet, simply select a banner that all the data is drawn automatically for their respective months, showing exactly how much you have to receive relative to the card in question.

how to control receipt of credit cards - analysis of installments receivable

Anticipation of receipts

To conclude, knowing what you have to receive, a possibility that opens to cover possible losses in months with many expenses is the anticipation of receiving these amounts. In order to understand whether it is worth making this advance, it is necessary to do the calculations correctly and in our card control worksheet we have an exclusive area of ​​anticipation where you add the rates and make on-the-spot simulations:

how to track receipt of credit cards - down payment forecast

That way, you can have total control of your installment receipts (or on credit), see if it's worth anticipating or not, and organize your finances by taking your credit cards into consideration.

banner credit card control worksheet

Excel Spreadsheets

2 COMMENTS

  1. Good Morning!
    I control the receipt of credit and debit cards at the company where I work.
    On the site I found interesting spreadsheets that would help improve control in the company.
    I would like to know what monthly cost of them?
    I await and thank you
    Att
    Aldo Alves

LEAVE AN ANSWER

Please, write your comment
Please enter your name