hi i am trying to include account code as part of my pivot table.need help desperately.Have tried a few , still not working.
E.G
Center Account code Amount
1. chatswood - 00-240-3650 250.00
2. atarmon 00-250-2800 480.00
etc, about 500 lines
Thanks for your help
Kruncy19
I am building a Project Finance Reporting Tool based on Pivot Table. The reporting tool will be distributed to all field offices to report on Cash, Expenditures for the month and Cash Advances given to individuals.
The Cash Book must show closing and opening balances respectively for each month and the running balances.
Cash in - Cash out = Cash Balance as at any given date
1)I am looking at something in the following lines
Jan 31 - $105,798.00
Feb 01 - $105,798.00
2) Opening Balance must show as the first entry in the Cash Book running balance, regardless of other transactions for the 1st day of the month.
3) How can I bring the opening balance into the Pivot Table.
5) Transactions for the month is selected based on Pivot Table Report Filter (Month/Year)
Any Help on the above will be greatly appreciated
Thank you
Rushdhi
Hi, i'm trying to make a table that i can keep track of all my accounts(A1:F6), and a table for each individual account(A9:E17)((A19:E27)((A29:E27). The thing is that if i enter information in on the all accounts table (A1:F6) the name of that account will receive that information as well.
I have two sheets. First contains Department # 0002549, and the other one contains 5 more digits(#02001 0002549). I will need to find the exact match for the first sheet to contain all 12 digits. THey are all in different order, so I probably have to match them first then add whatever the first 5 digits number. How should I tackle this issue? I was thinking to use vlookup but how could you use vlook up if only last 7 digit matches and add addtional digits to exisiting number? your help will be greatly appreciated thanks.
I am wanting to enter random data into excel in the form of :
Account Code Amount
300 560.44
309 51.00
270 350.00
etc.
I would like to have some way that I can insert a column between Account Code and Amount that would automatically contain the Account Description (i.e. text) of the corresponding account code, e.g. 300 is Accountancy Fees, 309 is Bank Charges, 270 is Purchases etc.
I would then sort the 3 columns using a pivot table (I know how to do that).
All help would be appreciated.
Thanks
Hi Guys and Gals:
I'm new to this forum, and a relative novice to excel.
I am trying to figure out how to use excel to make managing acounts receivable at my company easier. I often receive payment for multiple invoices, with no itemization explaining how the payment total should be applied (i.e. which invoices the payment covers).
If I have a check for a value of $100, for example, and I have three hundred invoices in a spreadsheet, I would like to use excel to analyze all of those invoices and return to me all the potential combinations of invoices that would add to that total. For example, invoice a (20) AND invoice b (80); or invoice c (10) AND d (10) AND e(20) AND f (60).
I realize my example would imply that this sort of function would not be particularly helpful, but my invoice amounts are for unique enough numbers that I think the combinations would be relatively few in number, and easy to identify.
Is this possible to do in excel? I'm not sure of how to describe this function I'd like to create mathematically.
Thanks in advance for your help!
I am trying to track when my invoices are paid, and can't seem to get it right. I have a column with the date due, and a column with date received. I enter the data "3-18-2003", etc. How can I get a measure of how many days between the two dates to track receivables?
Thanks!
B1 = Todays Date
C4 = Invoice Date
D4 = Due Date =IF(WEEKDAY(C4+30)=7,C4+32,IF(WEEKDAY(C4+30)=1,C4+31,C4+30))
E4 = Days Past Due =IF(B$1-D4120,$F4,"")
If E4 contains "Current" column K >120 picks up the amount rather than 0
If I change the formula in K4 to =IF($E4="current"," ",IF($E4>120,$F4,"")) it works correctly, but why doesn't the original formula work?
thanks for your help.
I work for a small weekly newspaper and we are attempting to come up with a simple bookkeeping spread sheet. We would like each salesperson to be able to enter their sales into their customer's accounts and at the end of the month be able to print a statement for each of their customers and be able to enter payments as received. Also since each is on commission, print out a report that tells commissions owed to them after payment is received at any given time. What we thought would be rather simple, has turned into a hair pulling experience. Apparently we are more simple than what it is or it's too much to ask. Ideas would be appreciated.
