Navigation: THE MAIN MENU >
The Database Menu
|Imports transactions from files whose file extension is .IIF (the format used by QuickBooks Desktop for importing transactions) or .S4AIF, for example bank deposits from the DONATION program, or transactions from a payroll system.
|Prompts for an online banking download file to import. Such downloaded files can also be automatically opened for importing, without having to use this menu option, by using the file associations and picking Open in your web browser when you download them.
Export Chart of
|Exports a file containing details about the accounts in your chart of accounts that don't have sub-accounts (the ones you can post transactions to), other than fund/equity accounts, for importing into other programs.
|Checks that your data has not been damaged in any way, for example by suddenly turning off your computer while ACCOUNTS is working on something.
|Checks for the extremely unlikely occurrence that you have any unbalanced transactions in the database (total debits not equal to total credits). It also checks for a type of error where an account that has sub-accounts, which should not be able to be used directly in any transactions, is somehow used in transactions (or in other places in the program that can create transactions using that account).
|Delete Old Data
|Deletes old transactions up to a fiscal year end date that is no later than 2 full years prior to the current date, and replaces them with a new rollup Opening Balances transaction.
|Deletes all transactions from your database, including any Opening Balances transaction, but leaves other setup information alone (such as the Chart of Accounts etc.).
|Delete All Data
|Deletes all data from your database, so that you are starting over with a new empty database.
|Create simply formatted ad-hoc reports and data extractions using SQL Select statements. (Most users would never need to use this option.)