accounts not showing on reports

[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. ???

[NeilZ]

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 ?

[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.

[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)

[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.

[NeilZ]

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 ??

[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.

[NeilZ]

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.

[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

[NeilZ]

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.