Importing FAQ's

Fields:

What is  the purpose for each field?  Do I need to map each?

How do I turn off Check Numbers (I'm in a depository account)?

Our check number field includes text ("Check #123"). How do I strip away the text?

We have non-standard date formats.  How do we import this?

Our date field for the bank is embedded within text.  How do we accommodate this?

Should my check amounts be positive or negative?

The amount field in our bank data doesn't have a decimal period (ten dollars is shown as 1000).  How do I handle this?

All of the amounts in the file are positive.  What do I do?

How do I use the 'Sign' field?

How do I use the 'BAI' field?

How do I use the 'Amount_Reverse_Sign' field?

QuickBooks - Importing from QuickBooks

QuickBooks - Report Modification
 

Files:

How do I delete the entire import (I accidentally imported an incorrect file)?

How do import a file that covers multiple periods?

How do I copy and paste from Excel?

How do I import an outstanding check list?

How do I import voided checks?

What are the International capabilities?  Can the system handle Euros and British pounds?

I can prepare the data in either Excel or text. Which is easier to work with?
 

How do I know what text format my file is in?

How do I create a new Mapping Template?

How do I set the default import directory?

How do we filter the Bank file by Account Number? Our bank combines the activity for all three bank accounts into one download file.  I've been manually sorting them in Excel and then importing them.  Is there a way to do this easier with the system?

The CFO wants us to do daily reconciliations, but we're having trouble with the Accounting Package's month to date report.  When we import the file, the system states 'Duplicate Check Numbers found in import file'.  How do we perform daily imports?

Knowledge Base Index: KB1005
Still need help? help@bankreconciliation.com