Creating Statements
Statements in SEE Finance are designed to be an exact replica of your financial institution's statement of transactions for the statement period. You can then use the records in the created statement to compare against your account's records. Creating statements is easy, just follow the steps below.
Creating Statements:
- Select the desired banking, investment, credit card or loan account from the Account List.
- Select the Statements View view by selecting the "Statements" button on the right of the top bar.
- Either use the Menu Bar and select "Accounts" then "New Statement" OR click the "+" button under the statements table.
- Choose how you would like to create your statement: "Create New Statement from File", "Download Statement", or "Create New Statement Manually".
Creating Statements from File:
- Find the CSV, OFX, QFX, or QIF file you would like to import in the "Open" file browser.
- Give the new statement a name.
- Select the statement's start and end dates.
- Set the statement's starting balance and then click "Open".
- Based on the type of file you selected in Step 5 you will be presented with an import window and should follow the instructions for importing those file types.
- Once you select the "Import" button, you're done creating the statement and can start reconciling the statement in the Reconcile Window.
Importing OFX & QFX Files
Importing CSV Files
Importing QIF & QMTF Files
Creating Statements from Download:
- Fill in the "Download Statement" window fields and click "OK".
- Next the OFX import window will raise and show the transactions downloaded for this statement.
***Make sure to check the checkbox in the Import column to import these transactions into the new statement.*** - Select the "Import" button and you're done creating the statement and can start reconciling the statement in the Reconcile Window.
Notes:
- The statement will not be created if there are not any transactions downloaded.
- If you do not elect to save your user info in Apple's Keychain you will have to enter your user name, password and account ID (account number) for each account every time you want to download transactions.
Creating Statements Manually:
- Give the new statement a name.
- Select the statement's start and end dates.
- Set the statement's starting balance.
- Your statement is now created. Now you will need to populate the statement with transactions to reflect the statement of transactions provided to you by your institution. You can do this by either entering each of the transactions needed to the statement just as you would in the transactions register or you can build the statement's list of transactions during the reconcile process. Refer to information on "Building a Statement In the Reconcile Window" on the Reconciling Accounts Using Statements page for how to build a statement during the reconcile process.
Notes:
- When reconciling an account for the first time it is unnecessary to create a statement to cover all your past transactions. You can begin where you left off from your previous means of tracking your account's records (using a conservative estimate of the date where you left off). If for some reason transactions known to already be reconciled are not properly marked as reconciled you can quickly mark them as reconciled making the account up to date. Select the Transactions View for the account and then use the "Start" and "End" date selectors under the table of transactions to display only the date range of the transactions known to be reconciled. With only the known reconciled transactions shown, you can then select all of these transactions (press "Command a") and then select "Mark Selected Transaction(s) as Reconciled" from the Transactions menu ("Command Shift R"). Then you can begin reconciling your accounts using statements.
- The "Ending Balance" for a statement is calculated by using the "Starting Balance" set for the statement and the amounts for transactions found in the selected statement.
- The "Reconciled Balance" in the Statements View under the table of statements shows the reconciled balance of all the transactions in the account's transactions register marked as reconciled.
- You can even add an image to the statement, such as a PDF file, by Control clicking the statement in the table and selecting to show the statement image. Then you can dragging the image to the statement image window that shows the application's icon. In the statement image window you can also choose to delete, print and save the image.
See also
Reconciling Accounts
Downloading Statements
Reconciling Accounts Using Statements
Reconciling Accounts Without Statements
Which File Type to Import?
Keyboard Shortcuts
List of Reconciling Accounts Topics