Can you collect and maintain the data in the desired format?.Did you like the Analysis + Visuals presented in the Dashboard?.Now that you have seen the Dashboard, you can ask yourself 2 quick questions.
Once you have the data ready, this is pretty much a plug and play template that you start using instantly for your own company’s analysis. Implementing Invoice and Payment Management Template Important Note about Data – For the Dashboard to function properly with your data, it’s very important to maintain the data in the desired format, rest is automated! □
Rest columns are pretty self explanatory.The back-end data is pretty simple to maintain there is just one Excel file with 2 sheets – Invoice Data and Receipts Data How many invoices have been set-off by payments made against the invoice (in-full or partial).How many invoices have been set-off under lump-sum payments.Total Billings, Amount Received and Balance Pending till date for the Customer selected.Some of the key metrics that are displayed are The objective is to show you in-depth customer and invoice level details. SCREEN 2 : INVOICES PAID AND UNPAID BY CUSTOMER Total Billing and Balance Pending till date for selected Customer.Total Billings and Amount Pending till date.The objective is to show you an over all Company and Customer overview. Screen 2 – Invoice Paid and Unpaid by Customer.Screen 1 – Company and Customer Overview.Video Tour – Invoice and Payment Management Template
My new Invoice and payment management template solves it, pretty elegantly! This problem gets further complicated when the customer sometimes pays against the invoices (in-full or partially) and sometimes pays lump-sum. Now the problem arises when the business owner needs to set-off invoices manually using FIFO (first in first out method) against the payment received till date to find out which invoices have been paid off. I even posted this as a little DAX / Power BI Challenge.īut the customer rather than paying in-full against the invoice, paid 2 lump-sum payments of $70 and $150. Recently I worked on an interesting accounting problem where the business owner was generating invoices but the customer in turn was settling the invoices in lump-sum payments.