Download and learn how to make your own bank statement format in Excel Sheet with Dr and Cr sign


Hello friends, yesterday night i make some tricks in Excel sheet, fortunately i found an idea and make a Bank Statement sheet in Excel.

I am Share this Sheet and also share how you make this your own.

Click here to Download Bank statement format in Excel

Learn How to make your own

1. Open the Excel program from your start menu or by double clicking a shortcut on your desktop.

2. Label your headings on the top row and leave open columns between your headings. A1 should be labeled “Method;” B1 should be blank; C1 should be “Date;” D1 should be blank; E1 should be “Description;” F1 should be blank; G1 should be “Debit;” H1 should be blank; I1 should be “Credit:” J1 should be blank; K1 should be “Balance;” L1 should be blank; and M1 should be “Cleared.”

3. Change your blank column widths to separate the data you will insert later. Click on the first blank column (B), hold the “Ctrl” button down and click on the other blank columns, (D, F, H, J; L). They will be highlighted in black. Right click your mouse on any black column. A drop down bar will open, click on “Column Width.” Change to “2″ and click “OK.”

4. Change your other Column Widths that will hold data to the size you desire. The most noticeable change will be the “Description” column. Change this to a Column Width of “27″ so it can hold enough text to record your information.

5. Format cells to hold currency. Click on “G,” hold down the “Ctrl” button and click on “I” and “K.” Right click on one of the black highlighted columns to see the drop down bar. Select “Format Cells.” On the “Number” tab, select “Currency” and choose your decimal places and dollar sign. This will make your form consistent.

6. Insert your starting balance. On the first row, you want to insert only your starting balance in the “K2″ cell. This will be the number all your debits and credits will be added or subtracted from

7. Insert your data beginning with Row 3. Check #’s, ATM, Deposit and other methods will be entered in Column A. Insert the date of the transaction (you may format this column by right clicking on “C,” “Format Cells” and selecting the date format you prefer). Enter the description and amount in the appropriate columns

8. Create a running balance. Click on cell “K3.” On the toolbar, click on the Auto Sum button which appears as a Greek letter “E.” A dotted, moving block will appear on “K2,” and you will see a bar under the toolbars with =SUM(K2). Insert your command after the K2: =SUM(K2-G3+I3) and click “Enter.” You have formatted your cell data.

9. Format the “Balance” column to update as you enter data. Click on the K3 cell, hold down the “Ctrl” button and click the letter “C” on the keyboard. This copies the format of that cell. Click on the K4 cell, hold down the “Ctrl” button and click the letter “V” on the keyboard. This pastes the format into that cell. Repeat the paste process as far down as you prefer

10. Reconcile your Excel spreadsheet to your monthly bank statement. Put an “R” in the Cleared column to indicate that an entry matches your bank statement and has been added or subtracted to your balance.

11. Verify your balance. Your bank statement may be different from your Excel balance. Certain transactions may not have cleared the bank that you have recorded. Take your Excel balance, and add or subtract any amounts that do not have an “R” beside them to your Excel balance. This total should match your bank statement balance.

How To add “Dr” and “Cr” sign in Excel

1. First Open Excel Sheet

2. “Right Click” on A2 Cell

3. Click on Format Cell

4. then Click on Custom and paste the string  to Blank bar (Download below File to view String)

String

5. Click OK.

6. write -5000  in cell A2 and you will see  5,000 .00 Cr

About these ads
  1. #1 by Http://Www.Bodybuilding.Com/Fun/Build-Muscle-Burn-Fat-Simultaneously.Htm on May 9, 2013 - 5:57 AM

    I took Prozac and it produced me shed wight.
    Irecentlystarted it once more and that i locate it very simple to avoid these day-to-day temptations to overeat or consume
    the incorrect factors.I really feel complete with
    just a few bites ! But it does have a few negative effects , granted every person is diverse but
    I’ve trouble sleeping ,get sizzling flashes and feel a bit numb .When I’m on it
    , it really is difficult to really feel pure excitement .
    Besides that , it tends to make me general a greater particular person .

  2. #2 by Rodrigo on May 8, 2013 - 5:51 AM

    Nowadays, I went towards the beachfront with my
    youngsters. I discovered a sea shell and
    gave it to my four year previous daughter and said
    “You can hear the ocean should you put this for your ear.” She placed the shell to her
    ear and screamed.
    There was a hermit crab inside and it pinched her ear.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: