Page 1 of 1

accounts not showing on reports

Posted: Wed Feb 25, 2015 1:55 pm
by bjsbrown65
I had a credit card liability account set up last year and it continues to work. This year I set up 2 other specific by cc number so I can keep up with the individual purchases/payments and have entered transactions in maintain manual checks. The new accounts are listed below the original on the COA and identical with it except for the account number and the name. No budget, etc. They are active. When pulling up reports, the already added account shows up; however, even with checking the show unbudgeted blocks, etc. they will not show up in any report. I'm at a loss. ???

Re: accounts not showing on reports

Posted: Wed Feb 25, 2015 4:32 pm
by NeilZ
bjsbrown65 wrote:I had a credit card liability account set up last year and it continues to work. This year I set up 2 other specific by cc number so I can keep up with the individual purchases/payments and have entered transactions in maintain manual checks. The new accounts are listed below the original on the COA and identical with it except for the account number and the name. No budget, etc. They are active. When pulling up reports, the already added account shows up; however, even with checking the show unbudgeted blocks, etc. they will not show up in any report. I'm at a loss. ???
What's the report level setting? Is it setup to show up in Cash Management Reports as a liability? Which reports are you trying to create? I seem to remember that liability accounts will not show up in many of the standard reports.

What are the account numbers of the one that shows, and the ones that don't ?

Re: accounts not showing on reports

Posted: Wed Feb 25, 2015 6:05 pm
by Jeff
What report are you looking at and do the accounts have a balance yet? Have you posted transactions to the accounts?

By default the balance sheet report will only print accounts with a balance. It does this so that if you have old accounts that no longer have a balance they are not shown on the report.

Re: accounts not showing on reports

Posted: Wed Feb 25, 2015 8:23 pm
by bjsbrown65
When printing, the report level setting is 6 and the on the COA, accounts are set as 5. One of the reports is the balance sheet. It will show the older account but not the newly created. Yes the accounts have had data added. They are checked to show up in cash management.
The accounts are set up as follows on the COA:

01-2419-000 CREDIT CARD PURCHASES Group Liability
01-2420-000 Credit Card Purchases Detail Liability (This is the one already set up and used last year.)
01-2422-000 Card 4877 Detail Liability (New)
01-2423-000 Card 4885 Detail Liability (New)

Re: accounts not showing on reports

Posted: Wed Feb 25, 2015 8:28 pm
by bjsbrown65
I decided to post and see if they showed up and they did. Is there any explanation for why they won't show even though show unposted transactions is checked.

Re: accounts not showing on reports

Posted: Wed Feb 25, 2015 11:52 pm
by NeilZ
bjsbrown65 wrote:I decided to post and see if they showed up and they did. Is there any explanation for why they won't show even though show unposted transactions is checked.
Where were they created? Were they unposted in that module or in Funds Accounting ??

Re: accounts not showing on reports

Posted: Thu Feb 26, 2015 11:20 pm
by bjsbrown65
They were created in AP manual check. I posted in AP and then in FA and they showed up. What I can't understand is on the Balance sheet report, it gives the option for unposted but they still won't show up unless posted.

Re: accounts not showing on reports

Posted: Thu Feb 26, 2015 11:26 pm
by NeilZ
bjsbrown65 wrote:They were created in AP manual check. I posted in AP and then in FA and they showed up. What I can't understand is on the Balance sheet report, it gives the option for unposted but they still won't show up unless posted.
I seem to remember that the included unposted transactions are only for those transactions that are in the FA unposted queue.

While the Cash Management Report will reflect unposted transactions in Contributions and AP, I believe its the only report that accesses the unposted transactions in other modules.

Re: accounts not showing on reports

Posted: Fri Feb 27, 2015 9:01 am
by bjsbrown65
Back to the drawing board. I wanted a way to have a running balance on these accounts without having to keep a paper trail. Thanks

Re: accounts not showing on reports

Posted: Fri Feb 27, 2015 12:26 pm
by NeilZ
bjsbrown65 wrote:Back to the drawing board. I wanted a way to have a running balance on these accounts without having to keep a paper trail. Thanks
Again, these are liability accounts, you can see what the balance is using the Cash Management Report. Remember, this is Fund Accounting (IE: Cash Basis) ... liabilities are required payments, as such the expense has already been entered and is tracked elsewhere, these just contain what must be paid to the card company.