SQL Server - how to insert balance amount data into a table

Hi I am developing a cash collection system using c# winforms. My problem is i want to find out the status of the existing bill. Ex: my bill no is 1 Amount to be paid is 50,000 Amount paid is 40,000 Balance is 10,000 So status is pending I want to design a table for this scenario... Any help

Hello
Do u want to create table or insert value
both are here

create table
(
@ID int,
@ BillAmount decimal(10,2),
@Paid Amount decimal(10,2),
@BalanceAmount decimal(10,2)

)
insert into to yourtablename 
(
ID
BillAmount 
Paid Amount
BalanceAmount
) values(@ID, @ BillAmount ,@PaidAmount ,@BalanceAmount )