Trial Balance

[Guest]

I have a worksheet with a sheet of data for each customer, including name,
transaction date, payment amount, and balance owing. I now would like to
build a trial balance to show the name, balance owing (as of the trial
balance date) and if payments are in arrears or not. I hope someone will be
able to help me with this.

 

[Guest]

As far as the name and balance owing, you can do a quick pivot table...

Data - Pivot Table
Select the table with data
drop the name info into the column fields
Drop the balance owing into the data fields

As far as payments being in arrears, not sure I follow how you would know
when someone is in arrears. Is there a certain number of days payment is to
be made by?

if so, I'd put in a column labelled Arrears and in the cells put, say,
=if(now()-transaction date>30,"Yes","No")

Then, you can drag this field into the Data portion of your pivot table,
then use the drop-down arrow in the data portion to show only "Yes" fields...

 

[Guest]

Thanks for the help...that will work.

As far as the name and balance owing, you can do a quick pivot table...

Data - Pivot Table
Select the table with data
drop the name info into the column fields
Drop the balance owing into the data fields

As far as payments being in arrears, not sure I follow how you would know
when someone is in arrears. Is there a certain number of days payment is to
be made by?

if so, I'd put in a column labelled Arrears and in the cells put, say,
=if(now()-transaction date>30,"Yes","No")

Then, you can drag this field into the Data portion of your pivot table,
then use the drop-down arrow in the data portion to show only "Yes" fields...