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

New checking account with previous year's entries...
https://splasm.com/forum/viewtopic.php?f=3&t=195
Page 1 of 1

Author:  John Fridinger [ Tue Mar 14, 2006 4:24 pm ]
Post subject:  New checking account with previous year's entries...

How can I create a new next year's account and import just some entries from last year's account... I need to move last the two and a half months of entries to a new 2006 account, and delete them from the 2005 account they are presently in... before doing reports for tax figuring, etc...

I've tried exporting and importing to a new account to see if a way revealed itself, but nothing happens with the .plist document that CheckBook exported- the import window just sits there, and none of the import window menu buttons above are active, other than Cancel and OK, etc., and when I say OK it just closes, empty...

Nothing in the help files seem to suggest anything...

I'm using 1.6.1 on a Powerbook G4 with the latest 10.4.5 osx system software...

Author:  keithg [ Wed Mar 15, 2006 10:43 am ]
Post subject: 

CheckBook does not yet provide a way for users to move Entries between Accounts, export based on a date range, or remove multiple Entries at once, which makes splitting an Account in two a bit more complicated than you might expect.

When we designed CheckBook's Accounts we did not foresee that some users would prefer to group the Entries for each year in separate Accounts, rather than keeping all of them in the same Account. Instead, we provided Filter and Account Summary options that allow the user to view Entries and summarize for a specific date range. Future versions of CheckBook will take your preference into account, allowing you to easily move one or more Entries between Accounts similar to the way email can be moved from folder to folder in Mail.app. That way you could simply create a new 2006 Account and drag the appropriate Entries from the 2005 Account to the 2006 Account.

One way to move a relatively large number of Entries to a new Account, which will not move Entry Notes, Schedules or Account Summaries, would be to:

1. Create the new Account for 2006.
2. Export the original Account to QIF.
3. Using TextEdit, carefully cut out the transactions in the QIF file that you do not want in the 2006 Account. The transactions will be sorted by Date, so it should be relatively easy to spot the group to cut out. Each transaction is delimited by a '^' symbol. You should not remove the '^' above the first transaction you remove. Here's an example of what each transaction looks like:

D12/29/2005
N2
PChevron
MVacation Gas
T42.38
C*
LGasoline
^

4. When you have cut out the transactions you don't need in the 2006 Account, save the file with TextEdit.
5. In CheckBook, select the 2006 Account.
6. Select Import from the File menu and choose the edited QIF file.
7. When the Import process is complete you will still need to remove the 2006 Entries from the original Account. To make this easier, you can tell CheckBook to stop asking for confirmation before removing each Entry - there's an option for this in CheckBook's Preferences, under the Entry tab.
8. Sort your Entries by Date so that all of the Entries you would like to remove are at the bottom of the sort.
9. Select the first Entry to remove and press the Delete key on your keyboard. The Entry should disappear, and the Entry below it should move up to take the removed Entry's place - and it should become highlighted.
10. Press the Delete key until all the 2006 Entries are gone. Be careful because there is no Undo.
11. Re-enable the preference to confirm Entry removal.

That should get you pretty close to what you need. If anything goes wrong during this process and you would like to start over, you can force quit CheckBook via the Apple Menu and the next time you launch it your Accounts should appear untouched.

Please let us know if you need any additional details or assistance, John. We'll help out as much as possible to get you set up for 2006.

Author:  John Fridinger [ Wed Mar 15, 2006 11:38 am ]
Post subject:  Thanks so much...

Thank you very, VERY much for your fast reply... It seems to be working just the way you said it would... And it is really great the way you keep supporting the software... keep bringing it forward... Who knows, maybe by next tax year it will be able to drag entries between accounts, but this is going to do fine in the meantime...

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