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:
Mapping Options are (Import Type set to Account):
Bank Acct No./Card No/Note
As of (Date)
Remind me to order checks…
Income Amt for Reimb. Expenses
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.