Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2009, 12:22 PM
Carol the Impaler is offline
Member
 
Join Date: Mar 2003
Location: ibpka
Posts: 3,855

Exporting/Importing Check Registers in Quickbooks


Please help me understand mapping in Quickbooks when trying to import a check register. I can't get it to work, and clearly I'm missing something/don't understand what QB needs me to do.

My corporate accounting office exports Quickbooks check registers into Excel to send to the local offices. I won't go into detail, but it would be great if these Excel files could be imported back into Quickbooks locally.

I get stuck because the headers from the exported file do not match the options QB gives me for mapping.

Exported file headers are:

Type
Num
Date
Name
Account
Paid Amount
Original Amount

Mapping Options are (Import Type set to Account):

Type
Number
Name
Description
Bank Acct No./Card No/Note
Opening Balance
As of (Date)
Remind me to order checks...
Income Amt for Reimb. Expenses
Is Inactive

I map Type to Type, Number to Num, Name to Name, As of (Date) to Date. But am I supposed to map Descripton to Account (this is a GL account in the export file)? What do I map Paid Amount to? When I map things according to the limited options I'm given, all I get is errors. I've tried it a couple of different ways, and it doesn't work. I get "0 files imported, save errors?"

I know I'm stoopid, but I don't get it.

Last edited by Carol the Impaler; 04-07-2009 at 12:23 PM.
  #2  
Old 04-07-2009, 03:07 PM
dracoi is offline
Guest
 
Join Date: Dec 2008
Posts: 8,867
Won't importing the register again duplicate every item in the registry? I may not be understanding what you're trying to do, but it sounds impossible to me using just Excel and QuickBooks (and I'm a QB Certified ProAdvisor). If you ask me, Intuit has gone out of their way to ensure that QuickBooks is incompatible with everything.

When I do Excel import/export operations, I use Big Red Consulting's Excel add-ons. http://www.bigredconsulting.com/
  #3  
Old 04-07-2009, 03:32 PM
Carol the Impaler is offline
Member
 
Join Date: Mar 2003
Location: ibpka
Posts: 3,855
In short, what I'm trying to do is effectively transfer the QB check register from a computer in Accounting to another computer with QB at the station. I want to duplicate what Accounting has in their Quickbooks on a different computer.

A cursory visit to the Big Red site, though, indicates this can't be done for free. God lord, that's a lot of converters, and that can't be good.
  #4  
Old 04-07-2009, 03:40 PM
dracoi is offline
Guest
 
Join Date: Dec 2008
Posts: 8,867
BRC's Transaction Copier will do that. It isn't free, but it's not unreasonable if it saves you a few hours of labor. The thing to watch out for is that you don't accidentally duplicate transactions and to remember that the import creates new transactions and cannot update existing ones.

I bought into BRCs tools after a QuickBooks Accountant Copy import failed and we had to figure out how to get 1700 new transactions from our Acct Copy into the client's copy. There was simply no way to do it with free tools in the 2008 version and I don't think that's changed in the 2009 edition.
  #5  
Old 04-07-2009, 04:36 PM
Carol the Impaler is offline
Member
 
Join Date: Mar 2003
Location: ibpka
Posts: 3,855
That's very, very helpful, dracoi. Thank you.

Once again, The Dope comes through and makes me look like a genius at work.
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 02:57 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.

Send questions for Cecil Adams to: cecil@straightdope.com

Send comments about this website to: webmaster@straightdope.com

Terms of Use / Privacy Policy

Advertise on the Straight Dope!
(Your direct line to thousands of the smartest, hippest people on the planet, plus a few total dipsticks.)

Copyright 2018 STM Reader, LLC.

 
Copyright © 2017