[go: up one dir, main page]
Scribd
Upload
64 views4 pages

Format and Use of Excel Invoice Tracker

The document provides an aging summary and invoice details for Billy Mark's Store. It shows that Billy Mark's Store has a total outstanding balance of $4,000, with $300 overdue by 657 days on invoice 1001, and $3,000 overdue by 614 days on invoice 1003. Additional customers ABC Holdings and XYZ Constraction are also listed with outstanding invoice balances.

Uploaded by

cv.tapinsejahteramandiri21
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
64 views4 pages

Format and Use of Excel Invoice Tracker

The document provides an aging summary and invoice details for Billy Mark's Store. It shows that Billy Mark's Store has a total outstanding balance of $4,000, with $300 overdue by 657 days on invoice 1001, and $3,000 overdue by 614 days on invoice 1003. Additional customers ABC Holdings and XYZ Constraction are also listed with outstanding invoice balances.

Uploaded by

cv.tapinsejahteramandiri21
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Company Name STATEMENT

Address: City_Name, State_Name, ZIP_Code


Contact: +1-(***)-***-****, Fax:+1-(***)-***-**** Date: 12/4/2023 7:16

Customer: Billy Mark Aging Summary 12/4/2023


Contact: Billy Mark Current: $0
Billy Mark's Store 1 - 30: $0
Street_Name, Town_Name 31 - 60: $0
Zip_Code, Province 61 - 90: $0
Phone: +1(000) 000-0000 > 90: $4,000
Fax: +1(000) 000-0000 Total Outstanding: $ 4,000.00

Invoice Invoice Customer Due Date Amount Total Paid Age Outstanding Status
Date ID Due
1001 Billy Mark 15-Feb-22 $ 1,000.00 $ 700.00 657 $300 Partial
1001 Billy Mark 13-Dec-21 $ 700.00 721 $700
1002 ABC Holdings 15-Feb-22 $ 500.00 $ 300.00 --- --- Partial
1003 XYZ Constraction 03-Mar-22 $ 2,000.00 --- ---
1003 XYZ Constraction 25-Feb-22 $ 2,500.00 --- ---
1002 ABC Holdings 13-Nov-21 $ 1,000.00 $ 1,000.00 --- --- Paid
1003 XYZ Constraction 26-Dec-21 $ 1,500.00 $ 1,000.00 --- --- Partial
1001 Billy Mark 30-Mar-22 $ 3,000.00 614 $3,000
1002 ABC Holdings 14-Dec-21 $ 1,500.00 $ 500.00 --- --- Partial
- -
Customer Name Invoice ID Customer Details 1 Customer Details 2

All Customers
Billy Mark 1001 Contact: Billy Mark Billy Mark's Store
ABC Holdings 1002 Contact: ABC Holdings ABC Holdings Company
XYZ Constraction 1003 Contact: XYZ Constraction XYZ Constraction Company
Customer Details 3 Customer Details 4 Customer Details 5

Street_Name, Town_Name Zip_Code, Province Phone: +1(000) 000-0000


Street_Name, Town_Name Zip_Code, Province Phone: +1(000) 000-0000
Street_Name, Town_Name Zip_Code, Province Phone: +1(000) 000-0000
Customer Deatails 6

Fax: +1(000) 000-0000


Fax: +1(000) 000-0000
Fax: +1(000) 000-0000

You might also like