Splasm Software Discussions :: View topic - Match account headers with downloaded headers

Splasm Software Discussions https://splasmstrands.com.splasm.com/

Match account headers with downloaded headers https://splasmstrands.com.splasm.com/viewtopic.php?f=3&t=7033	Page 1 of 1

Author:	robbglass [ Mon May 20, 2024 10:38 am ]
Post subject:	Match account headers with downloaded headers
Match account headers with downloaded headers Account headers: Date Check Type Description To/From Catagory Notes Amount Download headers listed in column: Memo Names Payees Ref # Transaction Types Each of these fields can be renamed by drop-down to one of the following: Catagory Check# Description Notes To/From Types How to import a downloaded file filling the account with data arranged to account headings ? My imported data either shows no data under a header or the data has switched columns ( ie: Description column shows To/From data ) CB Pro version 2.7.29 (1233) Thanks ! Rob Glass

Author:	Allan W. [ Mon May 20, 2024 12:49 pm ]
Post subject:	Re: Match account headers with downloaded headers
If you're dealing with a tab-delimited Text or CSV file, you can click the menu buttons labeled "Data Layout", then choose the option that corresponds most closely to the data in the column below, then everything should import properly. To see this process in action, check out the video tutorial we have on our YouTube channel here (starting at about 30 seconds in): https://www.youtube.com/watch?v=hfsJjAic3-A With something like OFX, QFX, QIF, or QMTF, things are a bit easier: there are individual menu buttons, one for each standardized field. So, just as an example, you'd click the menu button labeled "Import Payees as" and select the To/From Items option. Or, in the event, the Memo field in your file holds the real To/From Item names, set it to Import Memos as To/From Items. Should issues persist, feel free to shoot a message with your file attached to it over to us at support@splasm.com. Then, we'll be able to tell you the exact Import Options to use, in order to get the file imported perfectly.

Author:	robbglass [ Tue Sep 15, 2026 7:10 pm ]
Post subject:	Re: Match account headers with downloaded headers
Dear Allan, I've unsuccessfully tried importing OFX/QFX files from Chase Bank for the last several days. I have failed to import Description and Catagory items despite adjusting item contents in the Memos, Names, Payees, Reference #, and Types. This evening, I tried a .csv download. The Data Layout row has only two columns. How to add columns for Date, Check#, Type, Description, To/From, Catagory, and Amount ? With seven available columns, selecting an appropriate column header must be simpler than the Whack-A-Mole game I've played these last few days. Thanks ! Rob Glass CB Pro 3.0.3 OSX 15.7.9

Author:

Allan W. [ Wed Sep 16, 2026 8:23 am ]

Post subject:

Re: Match account headers with downloaded headers

The OFX/QFX situation could be due to a formatting issue. Would you be open to sending an actual QFX file you can't seem to import over to us in an email to support@splasm.com? Or, you’re always welcome to send a file saved in just the same way but containing only one or two transactions.

As for CSV, you should only see two columns in cases where the file itself only contains two columns, or when the format/encoding selections are mismatched. So, have you checked the raw data, like by opening the CSV in Numbers or a similar spreadsheet program? Or, if more than two columns are definitely in there, you might double-check that you have the CSV (Comma-separated values) option applied instead of Tab-delimited text on the first window that comes up as soon as you select the Import > Text or CSV menu option. Also, confirm you have the correct Text encoding option applied, within the same window.

Attachments:

Import CSV.png [ 131.61 KiB | Viewed 210 times ]

Page 1 of 1	All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/