UD.
JAYA RAYA
TOKO : UD. JAYA RAYA Tanggal 4/30/2012
JL. PAHLAWAN NO.11 RT. 18 Statement # [100]
DESA MARGA MULYA SP 4 KEC. KONGBENGCustomer ID [ABC123]
0813 5049 6700/ 0823 5163 2378
PENERIMA : Account Summary
M. AZIS LIAH BA Balance Due Rp 400,000.00
DESA JAK LUAY Payment Due Date
08 JUMLAH Rp
Account Activity
Banyaknya NAMA BARANG Harga @ Rp Jumlah Rp
2 Rp 200,000 Rp 400,000.00
PERHATIAN! Barang-barang yang sudah dibeli tidak dapat TOTAL : Rp 400,000.00
ditukar/dikembalikan
Tanda Terima, Hormat Kami,
[42]
HELP
[Link] © 2009-2014 Vertex42 LL
Getting Started
Customize the template with your company name, address, and other contact
information. Then, save a backup of the file to use as a template for future billing
statements you might want to create.
If you do not need the Statement # or Customer ID fields, you can clear these
cells without affecting the rest of the statement. If you do not use the Customer ID
field, edit the text in the Remittance section.
Update the customer info and save a copy of the file for each customer.
For the Due Date, you could use a formula such as =H3+30 to make the Due Date
30 days after the date you enter in cell H3.
Sending a Statement to a Customer
It is not a good idea to send the spreadsheet itself to a customer. They might not
be able to open a spreadsheet file, and your file might include information you do
not want the customer to see.
One of the best ways to send a statement, besides printing a paper copy and
mailing it, is to email the statement as a PDF attachment. You can create a PDF
with Excel by exporting to PDF or going to Save As and choosing PDF.
Account Activity Table
This is where you enter individual payments received, invoices sent, and fees
charged to the customer.
See the image on the web page listed above for an example of how you can enter
information into the table such as rent amounts due, payments received, and late
fees incurred.
In the first line of the table, either enter the "Balance Forward" amount in the
Balance column, or a "Beginning Balance" if this is a new customer.
The TYPE Column
This column could be used to indicate whether the payment was made in "Cash"
or if the payment was made by check, you could enter the Check Number.
The INVOICE Column
If the receipt is associated with an invoice that you sent to the customer, list the
invoice number in this column.
PAYMENT & AMOUNT Columns
The Payment column is subtracted from the balance, and the Amount column is
added to the balance, so payments are the amounts that the customer pays to
you, and the Amount column is for amounts that the customer must pay.
Additional Help
The link at the top of this worksheet will take you to the web page on
[Link] that talks about this template.
REFERENCES
TIPS [Link]: Spreadsheet Tips Workbook
ARTICLE [Link]: Simple Invoicing for Small Businesses
ARTICLE [Link]: Add a Customer List to Your Spreadsheet
© 2009-2014 Vertex42 LLC
Billing Statement Template
By [Link]
[Link]
© 2009-2014 Vertex42 LLC
This spreadsheet, including all worksheets and associated content is a
copyrighted work under the United States and other copyright laws.
Do not submit copies or modifications of this template to any website or
online template gallery.
Please review the following license agreement to learn how you may or may
not use this template. Thank you.
[Link]
Do not delete this worksheet
![UD. JAYA RAYA
TOKO :
UD. JAYA RAYA
Tanggal
4/30/2012
JL. PAHLAWAN NO.11 RT. 18
Statement #
[100]
DESA MARGA MULYA SP 4 KEC.](/p?url=https%3A%2F%2Fscreenshots.scribd.com%2FScribd%2F252_100_85%2F326%2F511831039%2F1.jpeg&__src=https%3A%2F%2Fwww.scribd.com%2Fdocument%2F511831039%2Fbilling-statement&__type=image)
