Free. Exclusive. Just for you.
Four unique services that make learning easier, faster, and smarter - only on our website.

Accounts Payable Ledger with entries for Supplier 1 and Supplier 2, including invoice numbers, amounts, due dates, and payments.

FREE 9+ Sample Accounting Worksheet Templates in PDF | MS Word | Excel

Educational worksheet: FREE 9+ Sample Accounting Worksheet Templates in PDF | MS Word | Excel. Download and print for classroom or home learning activities.

JPG 774×355 41.1 KB Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #148287
Show Answer Key & Explanations Step-by-step solution for: FREE 9+ Sample Accounting Worksheet Templates in PDF | MS Word | Excel
To find the missing Total Due amount, we need to add up all the individual Balance Due amounts listed in the ledger. The "Total Due" at the top represents the sum of all outstanding balances.

Step 1: Identify the Balance Due for each supplier.
Looking at the "Balance Due" column in the table:
* For Supplier 1 (Invoice 1-1005), the Balance Due is $13,000.00.
* For Supplier 2 (Invoice 256X5), the Balance Due is $450.00.

Step 2: Add the balances together.
$$13,000.00 + 450.00 = 13,450.00$$

Step 3: Verify with the provided Total.
The table shows a "Total Due" of $13,450.00 at the top right. Our calculation matches this number exactly. This confirms that the Total Due is simply the sum of the remaining balances owed to each supplier.

Since the question implies solving for the values or understanding the relationship, and the Total Due is already given as $13,450.00 which matches our sum, the problem is likely asking to verify this total or understand how it is derived. If the "Total Due" box was empty, the answer would be the sum we calculated.

However, often in these problems, if there are blank rows with "$ -", they contribute nothing to the total. The only active debts are the two listed.

Let's double-check the payments just to be sure the "Balance Due" figures are correct based on the "Total Amount".
* Supplier 1:
* Total Amount: $20,000.00
* Payments: $1,500.00 + $1,000.00 = $2,500.00
* Calculated Balance: $20,000.00 - $2,500.00 = $17,500.00.
* *Wait*, the table lists the Balance Due as $13,000.00. This implies there might be previous payments not listed in Payment 1/2 columns, or the "Balance Due" is a carried-over figure from a previous statement. In accounting ledgers like this, you typically trust the "Balance Due" column as the current outstanding amount unless asked to recalculate from scratch including hidden history. Given the "Total Due" matches the sum of the "Balance Due" column ($13,000 + $450 = $13,450), the logic holds that Total Due = Sum of Balance Due.

* Supplier 2:
* Total Amount: $1,000.00
* Payments: $150.00 + $200.00 = $350.00
* Calculated Balance: $1,000.00 - $350.00 = $650.00.
* The table lists Balance Due as $450.00. Again, this suggests prior payments or adjustments.

Regardless of how the individual balances were derived, the Total Due field is explicitly defined by the sum of the Balance Due column in this format.

Sum of Balance Due Column:
$$13,000.00 + 450.00 + 0 + 0 ... = 13,450.00$$

The value is already present in the image header. If the task is to fill in a blank or verify, the calculated total is $13,450.00.

Final Answer:
The Total Due is $13,450.00.
Parent Tip: Review the logic above to help your child master the concept of accounting worksheets templates.
Print Download

How to use

Click Print to open a print-ready version directly in your browser, or use Download to save the file to your device. The ⭐ Answer button generates an AI answer key instantly - useful for teachers who need a quick reference. Need a different version? Our AI Worksheet Generator lets you create a custom worksheet on any topic in seconds.

(view all accounting worksheets templates)

Printable Accounting Sheet
Accounting Forms, Templates and Spreadsheets
Income Statement Template | Free Download | FreshBooks
Worksheet: Trial Balance and Adjustments | Business Forms
Accounting Worksheet.mp4
Accounting Templates | Free Download | FreshBooks
Free Excel Bookkeeping Templates
Accounting Worksheet | Format | Example | Explanation
The Ultimate Excel Accounting Template For Bookkeeping
10 Best 8 Column Worksheet Printable - printablee.com