answersLogoWhite

0

You can set up several columns to cover this, like those you would get in your bank statement. The first column will have the dates of transactions. The second column will have the details of the transaction. The third column would have the values of credit transactions, money coming in, and the fourth column would have the values of the debit transactions, the money you are paying out. The last column will give you the balance after that transaction. That is done by taking the last balance and adding any credit and subtracting any debit.

So if you put each of these starting from column A having the dates, then column E will be the one with the balances. You would have to have an opening balance to start with. You would put the column headings in row 1. The opening balance will then be in cell E2. Row 3 will be the first one with the actual transactions. So in E3 you will have the formula

=E2+C3-D3

That will take the last balance in E2, add anything that is in the C3 cell, which will contain something if it is a credit transaction, and subtract anything that is in D3, which will contain something if it is a debit transaction. As you add in more transactions, you would copy the formula in E3 down and it will keep a track of your current balance. So every time you have a new transaction, you put it in on the next row.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Excel helps organize and identify your files by using what?

Excel can access a file manager. Excel helps you organize and identify your files by using Document Properties.


Excel helps you organize and identify your files by using which are the details about a file?

Excel is not a file manager. However, you can organize Excel files by storing them in folders for specific purposes.


What is used to organize and store data in excel?

table


Where could I purchase a Checkbook Balancer in the UK?

A checkbook balancer is easy to find online at affordable prices, but the absolute most efficient way to do it is to use Excel or Open Office spreadsheets instead of buying a gadget or new software.


Which applacation program helps organize data?

There are a few program applications that can help organize data. The main one that a lot of people use is Excel. Excel has many different settings that can help people organize data and can be personalized to meet all needs.


What software do you use to organize and manipulate large complicated groups of data?

Excel


Does Microsoft word and PowerPoint help you balance a checkbook?

No, those two are not good choices. If you have it, Microsoft Money or even Microsoft Excel will be much more useful.


Where can Checkbook Software be purchased online?

Checkbook software, such as CheckBook Pro, Quicken Checkbook and ClearCheckbook, can be purchased at a number of online software retailers. Examples of online stores that carry checkbook software are CNET, Amazon, Intuit and eBay.


What will help you organize information into columns and rows?

A graph/table, or Microsoft Excel, or Apple Numbers.


What does balancing your checkbook mean?

what are good facts about balancing a checkbook


When was Consumers' Checkbook created?

Consumers' Checkbook was created in 1974.


What are properties that include author title and subject in excel?

They are Standard Properties.In Excel you can specify your own text values for these properties to make it easier to organize, search, and identify your documents.