banking

  1. S

    FIFO Revolving Line of Credit Tracker with Interest

    Hi! I'm trying to create a FIFO (First in, First Out) Revolving Line of Credit Tracker in Excel. We buy "short-term" notes (aka, lines of credit) and pay back P&I throughout the month which gets applied to the oldest note first. The rates for each note fluctuates with WSPRIME. I've attached a...
  2. L

    I need a formula to check for duplicate values across a 10 day period

    I have a workbook that analyzes 3-5 years worth of bank information, I need to identify when money is being transferred from one account to another. IE. I move $10.00 out of account A and put it into account B. Currently I have a formula that will Identify duplicates that occur on the same...
  3. V

    Macro taking long time to execute.

    Hi all, Have to generate 640 files basis district name. The output sheets are formula based , they pull the data from input sheets. Mostly the sumifs formula is used. It takes almost 5 minutes to generate one single file. Perhaps with each change of district the calculation features takes time...
  4. J

    Power Query/M conditional row sums based on previous rows

    I have a data set containing dates and amounts for upcoming, cash flow causing accounts payable and accounts receivable transactions. Those are exported from accounting software and I use them for cash flow forecast. Other transactions are added manually to the forecast. Problem with those...
  5. J

    VBA - Macro for making banking file quicker to work with

    Hi everyone - First off, I want to say thank you all for being such great resources - I have received a lot of help from some of you on here! I'm hoping someone can help me with this particular request. I have a file with daily banking activity that I download every day. The report has tons...
  6. J

    VBA - Macro for making banking file quicker to work with

    Hi everyone - First off, I want to say thank you all for being such great resources - I have received a lot of help from some of you on here! I'm hoping someone can help me with this particular request. I have a file with daily banking activity that I download every day. The report has tons...
  7. M

    ModelOff 2014 - starts 25th October!

    Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...
  8. D

    Filtering content from one spreadsheet to show it in another

    I am creating an Excel spreadsheet designed to manage my company's accounts. Spreadsheet 1 is used like a bank statement to show payments going in and out of the company's bank account. Spreadsheet 2 is used as a cash flow chart. The sheet sis divided into left and right. Columns on the left...
  9. B

    Banking, account categories, creating breakdown $ spent on each category

    GOAL: Create table of debit card transactions, by month and organized into summed categories (food, entertainment, education, etc.), each of which being compared to income for that month (percentage of) WHAT I KNOW: - If statements (haven't ever used them in excel though) - basics of excel -...
  10. S

    applying categories to bank transactions

    Windows XP, Excel 2007 Okay, Column A is filled with bank transaction descriptions like: 123456789 ACCOUNT WITHDRAWL CHECK CARD 1234 GOODY'S CLOTHING CHECK CARD 5678 APPLEBEES RESTAURANT 123456789876 SOU WAL-MART 092834750298 SOU JCPENNYS STORE 20938209837 ... AND SO ON Column B is the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top