x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 6 replies
  • Subscribers 59 subscribers
  • Views 1911 views
  • Users 0 members are here
Browse Forums
Sage Timeslips Anywhere Announcements
6
topics
1
replies
Sage Timeslips Anywhere General Discussion
13
topics
13
replies
Sage Timeslips Premium Announcements
57
topics
17
replies
Sage Timeslips Premium General Discussion
2k
topics
8k
replies
singingal77

A/R Transaction Listings

Posted By

Hello - 

I'm looking to run a report that shows every amount we invoiced our clients for one year as well as what they paid in that same year.  Basically invoice amounts and payments for 1 year.  The invoice amounts look correct, but the payments that show up are very off.  For example, we invoiced a client $250 in February and the payment amount in March was $3290 (these are just figures I created, but similar to what I'm seeing in my report).  Many times the payment is much, much more than the client has ever paid us in their history.  Am I doing something wrong or is this a fluke in the report?

  • 0

    What reports are you running? You can run the invoice listing report total by client and the payment listing report also totaled by client. If you don't want to see details on each client go to options and choose only show totals and subtotals. You could also do a transaction listing report. Total by client and within client total by transaction type. Yo can show details or again only show totals and subtotals by using the options.

  • 0 in reply to Caren2

    I'm running an A/R by period report for 1/1/2019 - 12/31/2019.  It gives me the total amount we billed each client in that time period as well as payments made in that time period.  My problem is that the payments are not correct.  Example - one client we billed $710 in 2019.  Total payments are showing as $9,947 for 2019.  In the entire time this person has been a client, we have only billed them $2,411.

  • 0 in reply to singingal77

    I would then show more details in the report so that the program can essentially tell you how it is coming up with that number.

    Sounds like you may have "show only subtotals and grand totals" checked under options. I would UNcheck that to see each line item it is considering.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

  • 0 in reply to Nancy Duhon

    Show only subtotals and grand totals is unchecked when I run the report.  I guess I'll have to contact tech support to see what's wrong with the report.  

  • 0 in reply to singingal77

    Actually no, just reread the entire thread. I would not run a "by period" report because that will try to subtotal.  I would run an A/R Transaction Listing and then filter by dates and maybe Sort by Type so that you can get a total of Invoices, Payments, Credits, etc.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

  • 0 in reply to Nancy Duhon

    That's not at all what I need.  The report I mentioned is exactly what I need, but the data in the report is incorrect and does not match what we've entered as payments.  

*Community Hub is the new name for Sage City