Scribd
Upload
85 views77 pages

Supplier Reconciliation Template

Peter's Playhouse has a statement date of 10/5/2022, showing a balance of $250,000.00 with an adjusted balance of $255,700.00. The reconciliation includes various invoices and payments from the supplier 'Toys and Us'. Instructions for editing the template are provided, emphasizing ease of use and support contact information.

Uploaded by

zaim.muhd10
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
85 views77 pages

Supplier Reconciliation Template

Peter's Playhouse has a statement date of 10/5/2022, showing a balance of $250,000.00 with an adjusted balance of $255,700.00. The reconciliation includes various invoices and payments from the supplier 'Toys and Us'. Instructions for editing the template are provided, emphasizing ease of use and support contact information.

Uploaded by

zaim.muhd10
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/ 77

Peter's Playhouse

Address 6629 D Motts Boulevard, Rapid City, SD 88202


Email Address: pplayhouse@email.com
Contact Number: 555-222-7777

Supplier Name: Toys and Us

Statement Date as of: 10/5/2022


Balance: $250,000.00
Supplier Reconciliation
Supplier Name Toys and Us

INVOICES/ CREDIT
DATE DESCRIPTION
NOTES

10/4/2050 Computer Tables - Invoice #9204 $ 4,000.00

10/11/2050 Conference Tables - Invoice #6820 $ 5,000.00

10/13/2050 Payment for Softwood Lumber - Ref #1203

10/18/2050 Payment for Plywood - Ref #8320

10/26/2050 Supplier's Discount - Ref #3749


Peter's Playhouse
Address: 6629 D Motts Boulevard, Rapid City, SD 8820
Email: pplayhouse@email.com Phone: 555-222-
7777

STATEMENT DATE (AS OF): 10/5/2022

ADJUSTED BALANCE $255,700.00

BALANCE AS PER SUPPLIER: $250,000.00

UNCLEARED
OTHER BALANCE
PAYMENTS

$ 254,000.00

$ 259,000.00

$ 2,000.00 $ 257,000.00

$ 1,000.00 $ 256,000.00

$ 300.00 $ 255,700.00
The following are instructions on how to use the template.

1. Edit or add content like inserting rows and columns to the template.
2. There are no locked-up cells for easier editing of cell names.
3. All text or numbers in bold are auto-formulated.
4. Red highlights in the cells are negative numbers. To remove the conditional for
5. Feel free to change any formula.

Should you need assistance, please contact our Customer Support Team using the
e the conditional formatting watch thvideo clip.

port Team using the chat box found on the website.

You might also like