The Database Menu

<< Click to Display Table of Contents >>

Navigation:  THE MAIN MENU >

The Database Menu

Import TransactionsImports 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.

Import Online

   Banking DownloadPrompts 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

   AccountsExports 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.


Validate DatabaseChecks that your data has not been damaged in any way, for example by suddenly turning off your computer while ACCOUNTS is working on something.


Validate TransactionsChecks 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 DataDeletes 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.


Delete All

   TransactionsDeletes 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 DataDeletes all data from your database, so that you are starting over with a new empty database.


SQL SelectCreate simply formatted ad-hoc reports and data extractions using SQL Select statements. (Most users would never need to use this option.)




This topic was last edited on Mar 23, 2023