Microsoft Excel template payments receiving sending

Payment manager Ms. Excel workbook for payment record

Receive payment from customer

I created one Microsoft Excel template for payment receiving sending. You can record and write the payment and receiving amounts for business purposes. and no need for any paperwork. This is an online digital template in Microsoft Office Excel. You can use this template on a mobile device. when you are away from the office. You can use this template via OneDrive.

You can save payment received from your customer. international money for example Saudi riyal Qatar riyal BDT also currency convert in USD. And calculation by bank name, country name, monthly, and currency name.

How much currency. which bank receives. and how much has remained in the balance. is also shown in the dashboard of this template.

The main feature is this template

Payment collection is most important for businesses. need to write that amount for calculation for future calculations. Bank name and collect amount. you can see it in this table. and you can add new any bank name. In the bank list.

Customer list

The list of customers is of utmost importance for any business to grow. Customer table you can add a new customer name. mobile number and another messenger ID. and the next Colum will be shown more data like the customer's total amount

Product providers list

You can add your new customer your product supplier add an extra column will be showing many more data like this customer's total amount and remaining dues

Receipt Amount

This template has two main sheets. Payments and the recipient sheet automatic will calculate the amount you need to add receiving amount in this table other all work automatic will be calculated. The sheet will be calculated and exported data to the dashboard. monthly by year you need only add the year number in this year's cells.

Payments amount

In this table, you can add only the payment amount who is the collect payment from you and you can search it about half the table from the dropdown menu name and the system will be shown only result in the total amount brought on the name.

Account data advance filter customer or product provider’s

And sheet search your enter data by name, by date, bank, and amounts, and other value click now search button. the result from the table below will be showing the result.

Calculations on the dashboard.

Month years days on the one-click full automatically update records from payment sheet by product provider’s customer name record at full-year automatic showing.
And by the bank where you received payments from the customer and where you sent the amount for buying the product. You can download this file from the blue button please click on it here

If you like this template you can support me and contact us via email or comment