My client has a franchise that requires them to use proprietary software (Safe and Sound 2000) to report back to them. The franchiser has also written an importing link to QuickBooks using the .iif convention to create general journal entries. My client is using QuickBooks Pro 99 and has successfully imported the data as general journal entries. I was not with the client when they transferred the data. The problem is that the amounts post only to general ledger, itemized balance sheet and profit and loss detail reports, but do not post to trial balance, standard profit and loss or standard balance sheet reports. The QuickBooks program has detected no problem with data integrity using the utility/verify data command. Can you help me?
My client has a franchise that requires them to use proprietary software (Safe and Sound 2000) to report back to them. The franchiser has also written an importing link to QuickBooks using the .iif convention to create general journal entries. My client is using QuickBooks Pro 99 and has successfully imported the data as general journal entries. I was not with the client when they transferred the data. The problem is that the amounts post only to general ledger, itemized balance sheet and profit and loss detail reports, but do not post to trial balance, standard profit and loss or standard balance sheet reports. The QuickBooks program has detected no problem with data integrity using the utility/verify data command. Can you help me?
I generally recommend against importing data into QuickBooks. The main reason I do is because issues like you're bringing up are inevitably going to happen. However, since your client has already done it, you don't have a choice. First of all, what you've reported has to be slightly wrong. You say that the data was imported as general journal entries. I'm sure that's correct, since most other programs will probably only create iif files with journal entries. Not all, but most. Anyway, if you import general journal entries, they would show in all the "account-based" reports (Balance Sheet, P&L, General Ledger, Trial Balance, and Transaction Detail Reports). But you say that they "do not post to trial balance, standard profit and loss or standard balance sheet. This could not be true if transactions were really imported as general journal entries. To investigate further try this: 1) Create a Transaction Detail by Account Report. Set the date range for the whole year. 2) Find a transaction in the report and double-click it to display the transaction. 3) Assuming it was a General Journal transaction, you'll see a journal entry. If not, press Ctrl-Y to display the "Transaction Journal Report". This report shows the "journalization" of the entry and it shows all the accounts that are debited and credited by the transaction. 4) Now run a trial balance (or a standard P&L, or a Standard Balance Sheet) and set the date range to include dates where transactions were entered. You should see balances in every account that was hit by transactions in the last report. If not, you have a major problem, and I probably can't help. Check dates if you think it's not working. Every transaction has to have a date, and if the dates are wrong, your reports will be garbage.