How to run report for past months for Due From Client for Expenses

In QuickBooks, we have the a/r account entitled Due From Client for Expenses relating to expenses we've paid on behalf of clients.  How do I run a report in Timeslips that will show what the a/r balance is within Timeslips for past months?  Meaning, I want to know the a/r balance as of 01/31/13, and then 02/28/13, and then 03/31/13, etc.

Thanks.

  • 0

    You don't say what version of Timeslips, but in the last 7 or so, there is a report called A/R Balance By Date, which allows you to back date the day you want to run the A/R as of.  You would have to run it three  times to get the total balance by the dates you mention.

  • 0 in reply to MarcAC

    Hi,

    We are using version 2014.  Since I'm not the "normal" user of Timeslips (I'm the accountant who has self-taught how to use Timeslips), could you please provide the keystrokes to get this info?  Prior, I've tried extracting the data by going into REPORTS & A/R TRANSACTIONS, but then couldn't manipulate the settings to give me what I'm looking for.

    Thank you!

  • 0 in reply to tjsmags

    In your version 2014, click on reports on the menu bar and then billing.  You should see a report called Aged A/R Balances by date.  Open that report and choose the AR Transaction Date filter. As Marc suggested, run the report three times for Jan 31, Feb 28 and March 31 when that date comes.

  • 0 in reply to AllenH

    Thank you for your replies.  The above report is perfect for a/r balances IN TOTAL.  What I'm looking for is just the outstanding a/r for EXP items (slips?) only (so NO billable hours balances).  So, if we pay vendor XYZ $20 in Jan 2013, then client Jane Doe reimburses us in Mar 2013 for the $20 payment to vendor XYZ, I want to see the $20 as outstanding a/r for client Jane Doe up until her payment in Mar 2013.  Make sense?

    Again, right now i only want expenses that are outstanding (unpaid).  I don't care about the client's outstanding a/r for our billable hours.

    Thanks.

  • 0 in reply to tjsmags

    You should be able to get exactly what you need by clicking on OPTIONS and selecting the desired information.  Fees are hourly charges and Costs are the expenses.