The Database Menu

<< <%SKIN-STRTRANS-SYNTOC%> >>

Navigation:  THE MAIN MENU >

   The Database Menu

Import TransactionsImports transactions from files whose file extension is .IIF (the format used by QuickBooks for importing transactions) or .S4AIF, for example bank deposits from the DONATION program, or transactions from a payroll system.

 

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.

 

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

 

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