Topic Options
#20105 - 12/18/09 10:41 AM Bank Recs
Barb9 Offline
Adagio Prodigy

Registered: 03/06/06
Posts: 273
Loc: Langley
I would like to be able to import into Bank Recs from an Excel spreadsheet. Is this possible? It seems like it will only accept imports from "third party" programs. Does this include Excel?

Thanks very much.

Barb

Top
#20108 - 12/18/09 10:58 AM Re: Bank Recs [Re: Barb9]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi Barb,

What do you want to import? Deposits? Payments? Bank reconciliation?

Adagio BankRec can import all 3 from Excel sheets. You first need to set up templates from the File / Import menu. There is detailed information in the Help file as to how setting up templates works and what each field does, and what happens if a field is not imported. You create the template to match the Excel file columns, and set 'fillers' to skip the Excel columns that cannot be imported.

If this is for Payments or Deposits, use the 'Detail only' style of import template as this is geared towards Excel.

There are sample import files in the sample data directory (...\softrak\brwin\samdata) that match the default templates.
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 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