accounting

  1. T

    Multi-level doughnut chart in Excel 2013

    Hi All I'm hoping you may be able to help with an issue I'm experiencing when trying to create a multi-level doughnut chart using Excel 2013. It's a work project and I've modified an existing file that contains all of the income and expenditure during a month. It tracks a variety of data...
  2. C

    Need Fiscal Year/ Calendar Year matching days formula!! Please help!!!

    I work in grant budgeting and need to calculate fiscal year budgeted amounts based off of calendar year budgets. Usually the amount of calendar year days hits multiple fiscal years. See below; <tbody> Calendar Year Total Days Fiscal Year Total Days Days in CY 365 350 0 715...
  3. B

    Rolling Balances with Beginning Trial Balance

    Hi, I work as an accountant and am attempting to use financial data to create rolling balances. I have two Fact tables connected with various Dim tables. The first Fact table contains trial balance data at a given point in time i.e. end of month. The second table contains transaction data...
  4. Rhodie72

    Robust Small Business Account VBA system

    Thank you for taking the time to read this thread. Please help me keep this thread neat and useful to others by not posting anything that detractgs from the objectives It is about Accounting programs and systems being created in Excel VBA. It covers file management fundamentals; Double entry...
  5. T

    Monthly DeprecationFormula

    I'm trying to get a formula for current deprecation that depreciates monthly but I cant seem to figure it out I have it depreciating yearly at the moment. Can anyone see on my formula that I can tweak? =IF(AND(Life>0,LEN(Life)>0,[Acquisition Cost]>0,[Acquisition...
  6. B

    Accounting for day rates

    Hi guys, I have a billing sheet, looks roughly like the one below. At the bottom of the cost column is a total that tells me how much to bill a client for a particular job, based on the hours worked and the cost of those hours. However, if any individual does more than 80 units of work on a...
  7. G

    Help, Need Macro to reverse accruals in template

    Hello, I would like a Macro that will look for "A" next to a journal entry and copy the items to a new worksheet within the same workbook and transpose the account numbers & Item descriptions vertically.Any help would be greatly appreciated! Thank you! This is how the template looks...
  8. J

    Creating Formula to Match Old Account Structure with New Account Structure

    Hey all, I'm attempting to create a formula that will automatically search and paste the new account structure with the old. In short, the "location" in the new structure is different from the "location" in the old structure. The new location is determined by the old location account number...
  9. M

    No. of working days of employees.

    i want to calculate the no. of working days of employees. and situation goes this way: ENTER joining date in b2 ENTER leaving date in b3 and result displays in some cell. [Working days in a year is 313 or a year will be counted as 313]
  10. B

    Payment Terms in Excel

    I was wondering if anyone knew of a way to create a spreadsheet that would allow someone to enter an invoice date and have Excel automatically calculate payment terms of 2% 10th net 25? Example: Customer is invoiced 7/24. They must pay by 8/10 to get the 2% discount. Payment is due in full on...
  11. E

    Help with VLOOKUP

    Hi everyone, I am new to Vlookup and am comparing two columns in one spreadsheet tab to multiple columns of data in another tab. If the data is found in the second tab, then return the 6th column in the second tab. For instance, The first tab, cell C2 contains transactions, cell E2 contains...
  12. A

    Excel for accounting: 1 row of information, multiple rows of booking, copy down

    Hello, say I have multiple invoices that are all made the same way. Different VAT tax codes are invoiced. Total invoice = amount without tax + tax. These different VAT codes go into different rows in a second tab that specifies the tax code. For example: <tbody> Site ID Document Date Doc. Nr...
  13. E

    Compare Transactions in two Columns

    Hi, I know similar questions have been asked. I did search the forums but was unable to find a solution for my particular problem. Essentially, i want to compare transactions on a CSV exported file from my bank to the Fee paid on my business spreadsheet. The problem is that the CSV file...
  14. O

    Automating totals for keywords

    Hi, I am relatively new to Excel. I use it mainly for accounting, and realised that I was spending a lot of time doing repetitive highlighting of cells and copy/paste. I know the basics of programming so I'm prepared to dive in at the deep end. What I would like to do is the following: search...
  15. M

    Counting: Imbalances two columns

    Hi all. New to the forum - thanks for existing. Looking forward to sharing my knowledge too. Now - I have two individual sheets of 19.000 rows in one column. Sheet one is ingoing payments. (Positive numbers) Sheet two is (similar) outgoing payments. (Negative numbers) The sum of a sheet's...
  16. B

    Can't overcome formatting in unlocked cell

    Sheet in 2010 won't accept Accounting format. But it's not locked and not protected against formatting. Data appears left flush with no symbols. When new rows or columns are inserted, won't format these either. Other sheets in workbook are fine. Would appreciate any suggestions. :confused:
  17. T

    Matching two columns to sum their corresponding cells

    Hello, I have text data in column A and the corresponding Numeric(the debits) in column B. Also have text data in column C, and it's corresponding numeric (the credits) I'm column D. The data in Col C have more than one corresponding entry to Col A at times. How do I get Col A to match its...
  18. P

    Finding Unique Numbers within a list of notes

    I am working with journal entries. I am trying to find the unique numbers in a cell that also contains words. I am unable to upload the excel spreadsheet due to it being financials. But I can give examples. Here is are some examples: 2000 carpet clean for makeready. repair planking 1884. 2N205...
  19. K

    VBA Learner (Excel for Finance)

    Hi Guys I am sort of good at using excel for finance function for my job purpose. However I have come across some VBA enabled excel sheets which do excellent job. I would like to learn how to code VBA. I have started reading a book on VBA learning. It would be great if you can give me some...
  20. I

    Formula for Markup from COGs

    <tbody> <tbody> Units </tbody> <tbody> COGs (each) </tbody> <tbody> Total COGs </tbody> <tbody> Desired Margin </tbody> <tbody> Revenue (sell price) = COG/(1-m) </tbody> <tbody> Markup in percentage (?) </tbody> <tbody> 1,000 </tbody> <tbody> 5.00 </tbody> <tbody>...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top