Unpaid Invoices

[couevans]

Hey guys,

I sell directly to Amazon and need to create a template in Excel that keeps track of invoices that have been paid and have not been paid.

I can pull the data I need from remittance details in Amazon Vendor Central.

The remittance details include: Payment # Invoice# Invoice Date Description Invoice Amount Invoice Currency Withholding Amount Terms Discount Taken Amount Paid Remaining Amount

Can anyone please help guide me on how to create a template that will track this type of data?

Thanks in advance!

[mehmetcik]

A good Rule is "KISS" Short for Keep it Simple Stupid.

All you really need is a Unique number .............. Invoice Number

And something to tell you if it has been paid or not ie Y or N so two columns

However what happens if you then want to use the data for Tax or Accounting purposes?

It would be a pain to go back and type in all your data so additional columns should be invoice value Invoice Date and date paid

I have created something for you to look at.


Before you start enter the first invoice number in B2.

Now enter a value in A4.

Now enter p in D4.