I have a project to make a Settlement Statement in this format.

Column1 Column2 Column3 Colume4
Adv Deposits Guest City MonthtoDayfor Column 3
Previous Balance 0.00 0.00 300.0 -

Settlements --The Settlements Section will be Manual Entry
Net cash 0.00 0.00 0.00 0.00 450
Checks 0.00 0.00 0.00 600
Paid Out 200.00 0.00 0.00 500
F&B Paid Out 0.00 0.00 0.00 0.00
Lockbox 0.00 150.00 0.00 150
American Express 0.00 0.00 150.00 150
Discover 0.00 0.00 0.00 0.00
Visa-Pos 0.00 0.00 0.00 0.00

-- Calculated
Sum of Settlement 200.00 150.00 450.00 1850.00
Previous+Settlement200.00 150.00 750.00 3000.00

I want to use SQL to store the data for each days date. And when a new day starts automatically Bring the Ending Balance(Previous+Settlement) to the Previous Balance from the previous day.

I would like to use Visual Studio, but would I use a DataGridView or ExcelWith Visual Studio Tools for Office as a Form?

In this type of format what would be the best way to store the information in a sql database?

Thanks for your time.