I need a database to collect data from bank statements. The data will be used to code information for bookkeepers who will ultimatly enter the data into QuickBooks. I am building new sets of books for my businesses and personal accounts from the year 2000 forward. I have several companies some with several accounts and have used different banks over the years. I will also have personal bank accounts. The fields should include the business name, bank name, account number, transaction type, amount, date, category, payee or party, transaction id, and a comment field. I want a form for data entry. The form should "lookup" upon itself and or lists to minimize keystrokes. Many of the fields will have redundant information. The data should be able to be sorted by company, bank, date....and exported to QuickBooks or at least to Excel.

I have Access 2007 and Alpha 5 Version 9. It would be helpful for the database to be multiuser and accessible across my LAN and from remote users. A hosted site is a viable option. The database can be in some other format, SQL...with Access or Alpha 5 as a front end.

Skills: Accounting, Intuit QuickBooks, Microsoft Access

See more: alpha access 2007, access 2007 alpha, alpha database, type of account in accounting, sql data entry form, sql database business, remote excel, redundant data entry, quickbooks bookkeepers, payee id, my sql create database, my bank account number, field in accounting, excel data entry form 2007, end of year accounting, data entry keystrokes, data entry in excel 2007, data entry in banks, data entry in access 2007, data entry form in access, data entry form access 2007, data entry for banks, data entry alpha, create excel form for data entry, create data entry form in excel

About the Employer:
( 18 reviews ) Hot Springs, United States

Project ID: #533296

Awarded to:


Please see PMB for details. Thanks, Drew

$150 USD in 2 days
(6 Reviews)

6 freelancers are bidding on average $164 for this job


Hello Please Check your PMB.

$110 USD in 3 days
(29 Reviews)

Hello, please see PMB

$250 USD in 1 day
(6 Reviews)

I am an IT professional with 10 yrs experience. I have very good experience with SQL Server 2000/2005, Ms-Access 2000/2003/2007. I have completed many projects on GAF in Ms-Access skill. I will provide quick & professi More

$225 USD in 3 days
(5 Reviews)

I am in. Please share more details. Bye

$150 USD in 5 days
(0 Reviews)

we give u best quality and support

$100 USD in 2 days
(0 Reviews)