SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to index page
Thread view  Board view
Gregory West(R)

E-mail

Manitoba Canada,
05.10.2016, 09:27
 

Bug In Accounts Receivable Report (Patches)

I have bumped into an issue in the accounts receivable aging report. When I ask for an aging report in the past what I get is a report on all invoices created on or before the specified date and all payments up to TODAYS date, not the specified date.

What this means is I have a Balance Sheet saying I have 200K in AR on March 31st, 2016. But when I do an aging report I am told I have less then 10K. These two amounts should match. I am being asked for the aging of AR over time, and SQL Ledger is not able to do this. If this an easy fix, or is it a major change?

---
Gregory A. West
DB&W Systems Limited

DavidJ(R)

13.10.2016, 06:28

@ Gregory West
 

Bug In Accounts Receivable Report

I have bumped into an issue in the accounts receivable aging report. When I
ask for an aging report in the past what I get is a report on all invoices
created on or before the specified date and all payments up to TODAYS date,
not the specified date.

What this means is I have a Balance Sheet saying I have 200K in AR on March
31st, 2016. But when I do an aging report I am told I have less then 10K.
These two amounts should match. I am being asked for the aging of AR over
time, and SQL Ledger is not able to do this. If this an easy fix, or is it
a major change?

IMHO you're using the wrong report.
Aging (or Ageing) report is for sending Statements, eg monthly.
If you wanna see what woz outstanding at 31 March 2016, try
AR, Reports. Outstanding, To = 31/03/2016 (or 03-31-2016, or your format), Continue.
This report should be alignment with your Balance Sheet.
Tip. Tick the boxes, Due, Subtotal.
HTH

Gregory West(R)

E-mail

Manitoba Canada,
13.10.2016, 20:24

@ DavidJ
 

Bug In Accounts Receivable Report

I have bumped into an issue in the accounts receivable aging report. When
I
ask for an aging report in the past what I get is a report on all
invoices
created on or before the specified date and all payments up to TODAYS
date,
not the specified date.

What this means is I have a Balance Sheet saying I have 200K in AR on
March
31st, 2016. But when I do an aging report I am told I have less then
10K.
These two amounts should match. I am being asked for the aging of AR
over
time, and SQL Ledger is not able to do this. If this an easy fix, or is
it
a major change?

IMHO you're using the wrong report.
Aging (or Ageing) report is for sending Statements, eg monthly.
If you wanna see what woz outstanding at 31 March 2016, try
AR, Reports. Outstanding, To = 31/03/2016 (or 03-31-2016, or your format),
Continue.
This report should be alignment with your Balance Sheet.
Tip. Tick the boxes, Due, Subtotal.
HTH

Nice, this one is better, but can I get a subtotal by month not day. I need to get our auditors a statement at to the amount of outstanding AP / AR at 30, 60, 90 and 120+ days. They need this every quarter for sure, prefer every month.

---
Gregory A. West
DB&W Systems Limited

Gregory West(R)

E-mail

Manitoba Canada,
14.10.2016, 09:55

@ DavidJ
 

Bug In Accounts Receivable Report

I have bumped into an issue in the accounts receivable aging report. When
I
ask for an aging report in the past what I get is a report on all
invoices
created on or before the specified date and all payments up to TODAYS
date,
not the specified date.

What this means is I have a Balance Sheet saying I have 200K in AR on
March
31st, 2016. But when I do an aging report I am told I have less then
10K.
These two amounts should match. I am being asked for the aging of AR
over
time, and SQL Ledger is not able to do this. If this an easy fix, or is
it
a major change?

IMHO you're using the wrong report.
Aging (or Ageing) report is for sending Statements, eg monthly.
If you wanna see what woz outstanding at 31 March 2016, try
AR, Reports. Outstanding, To = 31/03/2016 (or 03-31-2016, or your format),
Continue.
This report should be alignment with your Balance Sheet.
Tip. Tick the boxes, Due, Subtotal.
HTH

Good morning. I tried the outstanding report using the dates From:2015-05-01 to:2016-04-30 (Their fiscal year) and the report came out blank. But on the year end balance sheet the AP is about 200K So this did not work either. Of course all these invoices are paid off as of today, but back in May they were not.

---
Gregory A. West
DB&W Systems Limited

DavidJ(R)

14.10.2016, 23:07

@ Gregory West
 

Bug In Accounts Receivable Report

Good morning. I tried the outstanding report using the dates
From:2015-05-01 to:2016-04-30 (Their fiscal year) and the report came out
blank. But on the year end balance sheet the AP is about 200K So this
did not work either. Of course all these invoices are paid off as of
today, but back in May they were not.

Good afternoon.
Beware of any "Journals" (aka General Ledger Transactions).
If you have any journals posting to your Recievable/s account/s, of course they're not included in AR report/s (which comes from the AR subLedger), and may explain any variance/s between your AR Outstandings report and Balance Sheet.
Refer Accounting 101.
In the absence of any journals, and assuming your Chart of Accounts constructed correctly, your AR Outstanding report WILL give same total/s as Balance Sheet at balance date.
To get these reports with 30/60/90/120 days ageing, you've a few options :
- Use the AR, Ageing report on the last day of each quarter, and save those reports for your auditor
- Use the Outstandings report at retrospective date/s, copy and paste the SQL-Ledger report to a spreadsheet. Apply your 30/60/90/120 ageing columns manually.
- Write a short custom report (and hopefully share it with the community).
HTH

Gregory West(R)

E-mail

Manitoba Canada,
21.10.2016, 14:11

@ DavidJ
 

Bug In Accounts Receivable Report

Good morning. I tried the outstanding report using the dates
From:2015-05-01 to:2016-04-30 (Their fiscal year) and the report came
out
blank. But on the year end balance sheet the AP is about 200K So this
did not work either. Of course all these invoices are paid off as of
today, but back in May they were not.

Good afternoon.
Beware of any "Journals" (aka General Ledger Transactions).
If you have any journals posting to your Recievable/s account/s, of course
they're not included in AR report/s (which comes from the AR subLedger),
and may explain any variance/s between your AR Outstandings report and
Balance Sheet.
Refer Accounting 101.
In the absence of any journals, and assuming your Chart of Accounts
constructed correctly, your AR Outstanding report WILL give same total/s as
Balance Sheet at balance date.
To get these reports with 30/60/90/120 days ageing, you've a few options :
- Use the AR, Ageing report on the last day of each quarter, and save those
reports for your auditor
- Use the Outstandings report at retrospective date/s, copy and paste the
SQL-Ledger report to a spreadsheet. Apply your 30/60/90/120 ageing columns
manually.
- Write a short custom report (and hopefully share it with the community).
HTH

Well as the case might be I have written a report in Jasper Suites, an awesome open source report tool. If someone would like for me to post it, no problem! Where is a good place to post it (have one for AR and AP) as well as a few other reports for Ledger123.

---
Gregory A. West
DB&W Systems Limited

Back to index page
Thread view  Board view
959 Postings in 314 Threads, 319 registered users, 126 users online (0 registered, 126 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum