Simple Ledger

May 30, 2009

This is going to sound very simply to most here I'm sure. I have a need for a simple ledger, credit, debit, balance. I will only have maybe 12 accounts and want to keep track of hand written invoices and payments.

Here's what I would like: I return to my office, click on a tab for an account, enter the date and amount of an invoice in a debit column for that account. When payment is made, enter the amount received in the credit column. Having a running total in the balance column. A monthly statement option would be nice, but not necessary.

I have searched for templates of general ledgers and get results with budgets, projects . . . just too complex for my needs now.

View 11 Replies


Journal Ledger Balance

Nov 12, 2009

Ref attached sheet

I m facing a big and urgent problem in my worksheet..i have done my all work here but now i knew that there is a difference in this vb code..

I need your urgent favour to rectify it for me..

What i need is sheet1 is my journal jounal (data) and sheet2 is my reporting place where i set a macro button at top to update the report..

But in sheet2 column I i need an auto Balance of debit & credit..

View 11 Replies View Related

Convert Data From SAP Ledger

Jul 31, 2006

Attached some sample data I am working on Data is ledger printed from SAP R/3 to .pdf using pdf995 Stripped from .pdf to .xls using Able2Extract

Column A represents unit number
Column B represents unit name
Column C I pulled account number from Col E if number otherwise 0
Col D I concatenated Col E,F,G is text color blue, otherwise 0.
I then filled Col D down to replace zero with value above non-zero.

Problem :
There is no account number in C2. I thought about using text in D2 for example and creating a lookup table. The problem with that approach is that exact samy text appears for balance sheet account as ledger account. Salaries& Wages for example is both accnt 216103 (bal sht) and accnt 911000 (ledger activity).

View 4 Replies View Related

Transfer Data From Journal To Ledger

Nov 18, 2009

how can transefer data from journal to ledgers accounts,

i can do journal and its formulas, ledger as well,

but i dont know how to connect them to avoid entring data 2 times.

View 14 Replies View Related

Create Ledger Account Based On Cashbook?

Mar 16, 2014

I want to create leger accounts In cashbook there is account head (ex. Hand Loan A/c, Salary A/c, Exam A/c and so on)

View 2 Replies View Related

Copy Ledger Account Names And Numbers To Each Row?

Apr 22, 2014

I've been working with ledgers to analyze companies financials in detail mostly using pivot tables and charts.

I usually get the data in a format that has the account name and number as a title on top and then each entry for this account under the title. In order to get my pivots working I need to copy the account name and number to each row until the next title.

Here is a picture to understand what I mean: Makrokyssäri.png

So is there a formula or a macro that could avoid doing the copying manually?

View 3 Replies View Related

Automated Posting From Journals To Ledger Accounts

Dec 28, 2008

I'm trying to set up automated posting from journal entries to ledger accounts.

What it boils down to is having XL match account numbers, from a 'Post Reference' column in a journal, with the corresponding ledger accounts (carrying the same respective account numbers) on another worksheet.

Then the transaction from the journal needs to be added to the identified ledger accounts in a sort of 'below-the-last-entry' manner.

View 5 Replies View Related

Create Ledger Account In Multiple Sheets?

Mar 13, 2014

I have CASHBOOK Worksheet and I want to create a LEDGER Account in Multiple sheet

View 2 Replies View Related

Extracting Data From General Ledger Download

Sep 20, 2006

For each account i download there are hundreds of pages of journals and entries, in the header of each page is information such as currency, the entries do not have have the CUR code (ie AUD, USD,CAD etc)

What i need to do is;
1. copy the CUR code to each entry line so that when i sort the data i have the CUR code to each entry

2. Copy the data to a "master" spreadsheet in it's unique tab if Column A begins with N and M.

View 9 Replies View Related

Sales Ledger Formatting - Insert Item Description Without Cut / Paste 25k Rows?

Sep 17, 2013

I'm working from a sales ledger file whereby I want all invoice data in one row although the Item Number & Item Description are on the first row. Rows 2-10 (for example) are the actual details of the invoice: Invoice #; Date; Customer ID; Customer Name; QTY; etc.

Is there a formula or easier way than copying/pasting the "Item Description" to the first column (J in this case) without any related invoice data?

View 2 Replies View Related

Excel 2010 :: Create Balance Ledger To Track Transactions At Different Locations

Dec 16, 2011

So I'm trying to create a balance ledger to track my transactions at different locations.

This is basically what I have:

C4 = numerical value for site A
D4 = balance for site A
E4 = numerical value for site B
F4 = balance for site B
G4 = total balance of both sites

Values for C4 and E4 are manually entered.

D4: =IF(OR(ISBLANK(D3), ISBLANK(C4)), "", D3+C4)
F4: =IF(OR(ISBLANK(F3), ISBLANK(E4)), "", F3+E4)
G4: =IF(AND(ISBLANK(D4), ISBLANK(F4)), "", D4+F4)

I have these formulas auto-filled to the bottom of the sheet of each column. The problem I'm having is that with this setup, the return on the G column is giving me


for all rows that do not have any values entered yet. Is there any way to fix the formula in column G so that it reads the value of the cell instead of the formula in the targeted cell?

I am using Office 2010 on Windows 7.

View 2 Replies View Related

DR & CR Match: Formate To The Modern Ledger Type Where There Are No Left And Right But Rather Laid Out In 1 Page

Apr 28, 2006

I have DR and CR entries which are laid out. in the traditional T format (under the Ledger tab). I would like to have it formatted to the modern ledger type where there are no left and right but rather laid out in 1 page. The required layout is shown in the Ledger attachment

View 2 Replies View Related

Insert Two Columns To The Right From Col H, Add Header Value "Ledger" In Col I1

Nov 22, 2008

I need a macro that will insert 2 columns to the right from Col H, add header value "Ledger" in Col I1 and "Statement" in Col J1. I then need the macro to put the values for ledger and statement next to each other as they are both related (as per below screen shot). I have highlighted which units are related so you can see that all related entries will have Ledg followed by Stmt and if they are not related then will be inputted under their relevant headings. I then want the macro to delete rows which have blank cells.

Ledg StmtUnitsLedgerStatementLedg389,351.00389,351.00599,811.00Stmt599,811.00Ledg148,822.00148,822.00209,536.00Stmt209,536.00Ledg1,674,562.001,674,562.001,661,564.00Stmt1,661,564.00Stmt111,110.000.00111,110.00Stmt7,738.000.007,738.00Ledg39,164.0039,164.000.00Ledg197,088.00197,088.000.00Ledg195,525.00195,525.000.00Ledg8,859.008,859.008,860.00Stmt8,860.00Ledg90,000.0090,000.00138,648.00Stmt138,648.00Ledg717717.000.00Ledg11.000.00Ledg5,314,520.005,314,520.000.00Ledg2,096,835.002,096,835.002,402,199.00Stmt2,402,199.00Ledg114,797.00114,797.00193,797.00Stmt193,797.00

View 9 Replies View Related

VBA Simple Right Function

Mar 31, 2008

Is there any reason why this wouldn't work in Excel 2007 despite working fine in 2003?

.Range("C2:C15132") = Right(.Range("C2:C15132"), 7)

View 9 Replies View Related

Simple IF Function

Aug 18, 2008

If Channel A = Channel B, only fill "Primary Channel" (A or B)

If the Revenue A is bigger than Revenue B then take the Channel A as primary and secondary channel column as Channel B

if the Revenue B is bigger than Revenue A then take the Channel B as primary and Channel A as secondary

Sample File


View 9 Replies View Related

Simple Loop To Get Value

Sep 27, 2008

I just like to do a simple loop but can´t seam to work it out.

I like to loop through column F and on the last cell or the first empty cell I like to get the sum.

how that works? I only find samples which don´t seam to help me much.

Also I would like to know a code to select all cells and rows and copy it into a different worksheet. Like cut and paste with vba.

View 9 Replies View Related

Simple Nested IF Statement

Mar 7, 2014

I am trying to do a nested IF statement in which if Cell A has a number, display it. If Cell A = "", look in Cell B. If Cell B has a number, display it but if its "", then display Cell C.

I have the IF statement working for the first two pieces but don't know how to incorporate a third statement: =IF(A="",B,A)

This works - how do I get it to check Cell B and show Cell C if B is empty?

View 2 Replies View Related

Simple Counting Cells

Mar 5, 2009

way to count cells in a spreadsheet (not values in the cells but just the cells themselves). So I have a whole bunch of cells, some are red, some are blue, some are green based on the info i have to keep track of.

so can i write some COUNTIF for red cells green cells, etc

View 14 Replies View Related

Inputbox For Simple Verification

Jun 3, 2008

I have a VBA userform with various textbox fields like 'Name' and 'Address' and 'Amount'
I would like an input box to pop up that asks the user to 're-enter for verification'
So that they have to type the same thing twice, to protect against typos

How do I code it so the program compares the inputbox to the textbox and passes only if they are identical?

(or even, using two inputboxes instead if that would be easier)

View 13 Replies View Related

Simple Insert Value Into Cell

Apr 6, 2009

What I would like to do is to insert the text "Agent" into the empty cell A# immediately above the block of names if "Agent" isn't already there. I'm having trouble with the syntax... The cell A# won't always be the same as the position of the block of names varies. In this case it's A9.

View 2 Replies View Related

Simple Cell Value +1 Macro

Jan 24, 2010

I'm trying to write a basic macro which will increase the value in a cell by 1 when I click on the button I've made. I've searched for hours on the Internet, including this site, and found several websites which give a formula needed but none of them work, I always get an "Object variable not set" error or something about sub-functions which I can't recreate so I can't give the full error message. Sorry.

Based on what I've seen on the Internet, I currently have:

View 14 Replies View Related

Add Condition To Simple Formula

Mar 26, 2009

Using Excel 2003. I have a very basic SUM formula I am using to show how many forms are still in-house. Pretty simple.

Column D is how many came in.
Column F is how many were completed.
Column E is what is left.

To get the daily count I take the previous day's Column E, add to today's Column D and subtract today's Column F.

Puts the results in E3.

This formula is copied on down the worksheet which results in:
=(E3+D4-F4), with the results in E4. And so on down Column E.

The problem is that if there is no data entered in Column D or F, the results from E are carried (copied?) as far down as the forumla. i.e., if today's column E results in 4, then that is displayed for as far down as I have copied the formula. What I'd like to do is set the formula so that if there is no data in columns E or F, then there is nothing displayed in Column E.

View 3 Replies View Related

Simple Private Sub Not Working?

May 7, 2012

Here is my simple Private Sub that I can't get to work,

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
For Each c In Target


I have a checkbox control that changes the value to "True" or "False" in column 4. Here lies the issue, if I use the check box control to change the value, the private sub does not work. If i type the value of "True" or "False" where the check box control stores its value, the private sub works. I would like to see if there is way to get the private sub to work by simply clicking on the check box control only.

View 9 Replies View Related

Simple If Array Formula

Mar 10, 2013

Trying to work out array formula.

basically if B2 = list of figures in range(F1:f22) then "G14" otherwise "".


doesn't work.

View 5 Replies View Related

How To Do Simple Table Lookup

Jun 23, 2013

How to do simple table lookup. I have a table showing #of colors being used for screen printing down one side and qty of shirts ordered going across the top. I would like a formula that when I enter the # of colors and the quantity of shirts it will return the correct price.





View 2 Replies View Related

Sum Of Simple Validation Results

Mar 26, 2014

Cell A1:A10 has a simple validation dropdown list of "Yes", "No", and "NA". Cell B1 has "if" formula if Yes selected in A1 then "1" is the result in cell B1, if no selected then 0 in B1 if NA selected then NA in B1. What is the formula to sum B1:B10, calculating the 1's and ignoring the "NA's"? I tried subtotal, sumif, etc.

View 2 Replies View Related

Simple Password To Run Macro

Aug 3, 2007

i need a way for a simple input box to come up and request a single generic password prior to runing a macro

View 9 Replies View Related

Open In A Simple Window

Nov 8, 2007

Is there a way that I can make an excel sheet and save it in a way that when it's opened the person JUST sees the cells in a really simple window...

Not sure if I'm confusing people in how I explain this... but basically I don't want it to show the scroll bars, the A B C D etc and 1 2 3 4 etc, the tool bars... etc. JUST the specified cells in a sheet.

View 9 Replies View Related

Send A Simple Email

Jan 6, 2008

i need to do is send an email via excel. In previous practice I have used the Activeworkbook.send method, but in this instance I dont want to send an attachment, all I need to do is send an email to someone, making use of the to: cc:subject and main body text fields.

View 9 Replies View Related

Simple Code In 'Private Sub'

Jan 8, 2008

I usually create fairly simple macros using 'button' feature. However, now I'm using the 'CommandButton', as I had to make buttons highlighted once selected - So I have a choice of five options, whichever the user chooses that option background changes, the others stay grey...anyway, thats the fancy-editing done, but now when i enter a simple instruction - hide rows function - I get the error message "Select method of range class failed"

Here is the full code - like i say it works fine when its just the editing, but when i try to actually hide rows it doesn't work. - I will also add that the code is inside 'Microsoft Excel Objects' and further 'Sheet 1 (INDEX)' - not a module - I'm not sure if this is important.

Private Sub JackStart_click()

JackStart.BackColor = 32896
JackStart.ForeColor = 16777215
JackStart.Font.Bold = True
Majix.BackColor = 8421504
Majix.ForeColor = 0
Majix.Font.Bold = False

Sheets("Bank Reconciliation").Select
Selection.EntireRow.Hidden = True


End Sub

View 9 Replies View Related

Copyrights 2005-15, All rights reserved