Archive - Getting Started - Register and Transaction basics
This is an archived document. Please refer to the more recent knowledge base articles on this page
What is a transaction?
A "transaction" is any change in the balance of your accounts, plus all the information about how much was spent or received and where the money went or came from. Moneydance uses the double entry method of accounting, which means that every transaction is a link between accounts (or categories). The value of one account or category will increase and another will decrease when a transaction is made. Transactions can be between a financial account and an expense or income category, or between two financial accounts (such as a transfer from a checking to a savings account).
How can I view, sort and filter the Account Register?
The account register displays all transactions in the account and is used to enter, edit, and delete transactions. It is visually similar to a paper checkbook register. To open an account register click on an account name in the Side Bar or Summary, or select the account name from the drop-down box in top left of the Moneydance program window.
The filter buttons running along the top of the register allow you to to restrict the transactions displayed in your register. Click “All” to see every transaction in the register, or one of the time frames to see a sub-set of transactions. Click the “Unconfirmed” button to show downloaded transactions which have not yet been confirmed or the “Uncleared” button to only display transactions which you have not yet marked as cleared. You can read more about downloading and confirming transactions in this article, and clearing transactions in this article.
The Split Register button at the top right of the window toggles between showing Confirmed and Unconfirmed transactions in a single pane, or showing Confirmed transactions in the top panel and Unconfirmed in the bottom.
You can change the order of transactions in the register by clicking on any column heading. Click twice to reverse the sort order. To sort the register by more than one variable, such as by date and then by Check #, Ctrl+Click (or right click) in the transaction register and select Sort By→
What are the different Transaction Fields?
You can create a transaction in any register except in a Loan Account (User Guide Chapter 11).
Investment Accounts have a slightly different set of fields, which are explained in detail within the User Guide, Chapter 7.
With the exception of Investment accounts, all account registers have the same format, and contain the following fields:
- Date - The date on which the transaction occurs.
- Tax Date - The date of the transaction for tax purposes, if different from the normal transaction date. This is only displayed if you checked the “Use Tax Date” box in Moneydance→ Preferences→ General (or File→ Preferences→ General on Windows and Linux).
- Check# - Selecting the {Print} option will include that transaction when printing checks. Selecting the option will insert the next sequential check number for that account. To edit the options for this field, go to the Summary and open the Account→Edit Account menu item.
- Description - The person or entity who receives or gives the funds. To enter an address book entry in this field use the down arrow key. Downloaded/imported transactions which are unconfirmed are marked with a small blue dot, confirmed transactions are marked with a small blue circle, split transactions are marked with a small “s”, and transactions with an attachment are marked with a small paperclip. Address book entries are prefaced by a green @ symbol.
- Memo - Any additional information. The exact dividing line between Description and Memo is mainly one of personal taste or financial institution download format.
- Category - The "other side" of this transaction. To make a transfer between accounts (from a savings to a checking account, for example) the account that the transfer is with should be selected in the Category field.
- Tags - Any tags you wish to assign to this transaction.
- C - A blank space here indicates the transaction is uncleared; an orange diamond indicates it is reconciling; a green circle means the transaction is cleared.
- Payment - Amount removed from this account and added to the account specified in the Category field described above.
- Deposit - Amount added to this account and removed from the account specified in the Category field.
- Rate - Specifies the exchange rate for inter-currency transactions. Automatically entered if you have installed the Quotes and Exchange Rates Updater extension. For information on manually entering an exchange rate, please see Chapter 14 of the User Guide.
- Foreign Amount - Permits entry of the exact amount of the other currency in a multi-currency transaction. See link above for User Guide, Chapter 14, 'Multi-Currency Support'
- Balance - The current balance of the account; this field is not editable
How can I enter a transaction?
To create a new transaction click the New Transaction button at the top right of the Account Register screen. The New Transaction dialog box is located at the very bottom of your screen. You can also create a new transaction by typing ⌘N. Double-click on an existing transaction to edit it.
How can I create a transaction containing more than one category?
Sometimes you may want to create a transaction containing more than one category. For example, you may make a purchase at a grocery store with is partially groceries and partially a reimbursable business expense. You can read how to create a 'Split Transaction' in this article.
Can Moneydance auto-complete my transaction entry?
Moneydance has an auto completion feature for transactions. Transactions can be auto completed by typing in the payee field. With each keystroke, past transactions are searched for payees with names that begin with the text already entered.
If a matching transaction is found, the rest of the current payee field is filled in with the matched payee value. At this point you can either continue to type, or use the TAB key to continue to the next field. Using the down arrow while auto-completion is active will display all address book entries and recent payees that begin with the letters that have already been entered and allow you to select one of them. You can opt to have auto-complete be case sensitive or non-case sensitive. You can edit this preference in the File→Preferences→General menu item.
Can I add Attachments to transactions?
To more easily track and reference receipts you can attach image files (PDF, JPG, and other image files) to transactions. You can attach multiple image files to a transaction.
You can attach a file to a transaction by dragging the image file onto a transaction in the Moneydance program window, or by right clicking on the transaction (or Ctrl+Click on a Mac) and selecting “Add attachment” from the menu which appears. Once you’ve attached a file to a Moneydance transaction a copy of the image will be stored in your Moneydance data file, and the original file can be deleted (if desired).
Transactions which have attachments will have a paperclip icon in the description field.
To see an attachment click once on the transaction. In the window which appear click “Details” to see a thumbnail of the attached file; click once on the file to view, or click the X to delete the attachment.
Can I add Tags to transactions?
Transaction tags provide another level of expense or income tracking. While you may track your vacation in several categories, such as Lodging, Food, Gas, etc, a tag will permit you to easily track and run reports to determine the total cost of the trip.
To enter a tag, begin typing in the Tags field. To assign multiple tags to a transaction enter a comma after each tag.
You can read more about working with tags in this article.
What are the keyboard shortcuts?
You can read about Moneydance keyboard shortcuts in this article.
Didn't find the information you were looking for? You can find more information on the Moneydance register and transaction features in this article.
-
Purchasing and Upgrading
-
Accounts and Categories
-
Register and Transactions
-
Budgeting
-
Online Banking and Bill Pay
-
Moneydance+
-
Reminders
-
Graphs and Reports
-
General
-
Investment Accounts
-
Loan Accounts
-
Syncing and Sharing Data
-
Currency and VAT/GST
-
Backups and Exporting
-
Importing Data from Other Programs
-
Customizing and Preferences
-
File Locations and Changes
-
Foresight
-
Extensions
-
Moneydance 2017
-
Linux
-
Older Versions
-
ARCHIVE - Getting Started
-
ARCHIVE - Moneydance 2017
- Archive - Moneydance 2017 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2017 from Moneydance 2012, 2014 and 2015
- Archive - Upgrading to Moneydance 2017 from Moneydance 2011 or earlier
- Archive - Changing colours and theme in Moneydance 2017
- Archive - Sharing data using the Moneydance 2017 syncing engine
- View all (15 more)
-
ARCHIVE - Moneydance 2014 and 2015
- Archive - Moneydance 2015 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2015 from Moneydance 2012 and 2014
- Archive - Upgrading to Moneydance 2015 from Moneydance 2011 or earlier
- Archive - Opening a backup file in Moneydance 2015
- Archive - How to restore from a checkpoint in Moneydance 2012 and 2014
- View all (3 more)
-
ARCHIVE - Program Basics
-
ARCHIVE - Account Basics
-
ARCHIVE - Entering Transactions
- Archive - Does Moneydance allow for assigning 'classes' to transactions?
- Archive - How do I get the Register to auto fill todays date instead of the last entered date?
- Archive - How do I move a transaction to a different account?
- Archive - How do I enter my Paycheck?
- Archive - How do I create a split transaction?
- View all (2 more)
-
ARCHIVE - Online Banking
-
ARCHIVE - Mobile
- Archive - Syncing Moneydance 2015 with your Mobile Device
- Archive - Syncing Moneydance 2012 and 2014 with your Mobile Device
- Archive - How to sync with Moneydance 2008, 2010, and 2011
- Archive - How do I delete a transaction on the iPhone, iPad, or iPod touch?
- Archive - How to sync one data file with multiple iOS devices using different Dropbox accounts
- View all
-
ARCHIVE - Budgeting and Reminders
- Archive - Creating reminders (automatic repeating transactions or notes)
- Archive - Creating a budget using the 'Newer' format
- Archive - Creating a budget using the 'Mixed Interval' (Older) format
- Archive - What's the difference between a General and Transaction reminder?
- Archive - How do I have a reminder automatically entered into my register?
- View all (1 more)
-
ARCHIVE - International Tools
- Archive - Setting up VAT/GST
- Archive - Can you change the word "Check" to "Cheque" anywhere in the programme?
- Archive - How can I enter the exact amounts on both sides of a foreign currency transfer?
- Archive - My household/country/company uses a fiscal year instead of a calendar year. Can I do this in Moneydance?
- View all
-
ARCHIVE - Investments
- Archive - How do I add Securities to a new Investment Account?
- Archive - How can I import security, stock or mutual fund prices?
- Archive - Entering your current holdings
- Archive - Creating a new investment subtype
- Archive - Downloading security, stock or mutual fund prices from non-US stock exchanges
- View all (5 more)
-
ARCHIVE - Extensions
-
ARCHIVE - Everything Else