Topic Options
#45331 - 04/14/15 02:10 PM Import to bank rec
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
Is there a blank excel emplate somewhere for importing journals into the Bank Rec module?

Thanks!

Top
#45334 - 04/14/15 05:35 PM Re: Import to bank rec [Re: ASANTOS]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3612
Loc: Toronto ON, Canada
There are sample files in the Bank Reconciliation sample data. The files are different for Payments and Deposits and must be imported separately.They are in comma separated format (CSV).

CSV file for Payments = \Softrak\BRWIN\SAMDATA\BRPAYIM.csv
CSV file for Deposits = \Softrak\BRWIN\SAMDATA\BRDEPIM.csv

The best approach is to first test in sample data so that you can see what the Import template must look like.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#45335 - 04/14/15 05:50 PM Re: Import to bank rec [Re: ASANTOS]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
You should also refer to the Import/Export Document on the Tech Tips page on our web site, and also the F1-Help on the Import Template definition dialog.

You can import Receipts, Payments and Bank Statements (for electronic reconciliation).
_________________________
Andrew Bates

Top
#45424 - 04/22/15 07:05 PM Re: Import to bank rec [Re: Bruce Gardner]
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
Thanks! I'll start with these

Top
#45425 - 04/22/15 07:05 PM Re: Import to bank rec [Re: Retired_Guy]
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
I'll be sure to check it out. Thanks!

Top


Moderator:  Softrak Support 
Who's Online
1 registered (AudreyQuick), 62 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70634 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30