payments

  1. N

    Managing Payment table separate from billing, calculating lps on every received payment based on criteria.

    Current Scenarios: My office colleagues are recording account receivable and sales data in sheet4, however, some companies have started multiple payments during the month and it is now difficult to manage them in this format. Action: so I decided to make new sheet for recording payments, which...
  2. T

    Monthly payment calculator

    I'm looking to break down a total charge into monthly payments. B2 contains the total charge B3 contains the number of monthly payments B5 contains the first instalment B6 contains the remainder This would be simple if the amounts were spread evenly, but I want to make sure that any pence are...
  3. A

    exel 2002 total accumulated payments

    i need to know what is the toal of monthly payments i have made i have forgotten how to include a spreadsheet on this forum post! thanks all <colgroup><col style="mso-width-source:userset;mso-width-alt:2560;width:68pt" width="90"> <col...
  4. P

    SUMIFS - Greater than first of month, Less than end of month

    Good morning, I have a sheet (Payments) with the following layout: <tbody> Date Account Amount Rec 26/10/19 Barclays 100 Yes 02/11/19 Barclays 100 Yes </tbody> On a different tab (October 19), I am trying to use a SUMIFS formula to gather all payments that occurred to Barclays in October...
  5. B

    conditional formatting

    is there a rule I can setup so that the account number in column B highlights in red if I have a word in the description column I that would make it jump out as the incorrect account? like bonus payments go to 6950 and commission payments to 6955. I sometimes accidentally post them to the...
  6. T

    Generating 2 rows on a different spreadsheet based on a value

    Hi All Our accounts software accepts bulk upload of journals from excel, the format is as below: <colgroup><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody> Batch Date Batch Description Batch Type Main Location Nat Dept Amount Description Journal Code 20/08/2019...
  7. S

    Searching Value in ComboBox as per comboBox Columns

    Hello I would like to search values of Combobox Column values For eg typing J in comboBox column 1 it should dropdown the list with all J and respective range in column2 Now if i type A or D or : in column 2 dropdown list to display all the names and and range if typed Specificaly the Range...
  8. M

    Xcel newb needing help calculating simple interest on a judgment

    I have used court calculators in the past to calculate the amount of interest (simple) owed, to-date, on a judgment but have been tasked with something I am unaware how to solve. My best best was to figure out an Xcel formula in hopes of simplifying my life. Judgment was awarded on December...
  9. S

    Part 2 : Few Details required of Individual's Name with Range Address in ComboBox

    Hello Wanted the List of Individuals Name with their Range Address uploaded in combobox So when the form is initialized all the individual's name with range address is displayed in the combobox When clicking on each name in combobox i get the respective information in respective textboxes. in...
  10. S

    Few Details required of Individual's Name with Range Address

    Hi I would like to get the range Address of Each Individual Name against payment made to them and received from them and few other details from each individual name. All the names are in column B if you see below For eg if I type Kate in txtName.Text to get the range Address ie A15:D23 in...
  11. S

    Power Query Unpivot?

    HI, I have a power query table with payments made on a transaction. I would like to have all payments on one line for each transaction so I can link them to the sales table. But if a customer paid with 2 credit cards in power query it is listed on 2 lines. I was hoping to use the un pivot and...
  12. C

    Compound and simple interest VBA?

    Hi all, hoping someone can help me solve a complex query I have. I have a large spreadsheet which has unique reference numbers in col A and month-year (ie oct-06) across row 1 (from oct-06 to mar-18). The fiscal year for the spreadsheet is from 1-April to 31-March which is causing me problems...
  13. 2

    Pivot tables - Consildating payments into one

    Hi everyone, I'm new to this forum. I need some help with pivot tables: I'm trying to consolidate payments Ids together, specifically payments which have the same ID but different payments need to be combines and totalled into one. I done a head-start with pivot tables. I comparing and...
  14. R

    Autonumber Payments

    Good day, Tried searching for this, but was unable to come up with anything that solved my problem. I am trying to write a formula to autonumber the payments received from each customer. <TBODY> ID Payment # 1001 1 1001 2 2001 1 3001 1 1001 3 2001 2 </TBODY> Having...
  15. J

    Can I search a client and his payment to decide Paid or Unpaid in his statement

    Dear All Excel Experts I have my sheets: Clients, Payments, Statement In the Statement sheet I tried my best that Excel automatically looks for the payment of the client and decides "Paid" or "Unpaid", but in vain. I have hope that experts will help my solve this problem. By the way the payment...
  16. R

    Counting Payments Based on Rows and Columns

    I am trying to count the number of payments (non-zero) made in a fiscal year based on the property. I can do a Countif for each column but there can be a large number of columns (properties) so I would like to be able to create a formula using the whole array that can reference the property and...
  17. M

    Creating a log of check payments

    On the Payments tab in column O I have dollar amounts of payments received in cash and checks. In column Q there are payment types of either "Cash" or a numeric value for the check number. I would like to have a Summary tab that pulls over the check payments based on what is designated as...
  18. M

    Sum total based on separate column criteria

    in Column O i have dollar values. In Column Q I have the source of the funds (cash or check number). On a different Summary tab I want to have a sum total of all the cash payments in one line and all the check payments on another line. Could you please help me with the best formula to use for...
  19. J

    Help referencing most recent payment date

    Hello All, Thanks in advance for whatever help comes my way. I have been doing a lot of research on how to return the date of a most recent payment, unfortunately, my situation seems to be a little different than what the videos out there are showing. Bottom line, I have a running daily...
  20. G

    Assistance with Excel Index's

    Hi All, I was wondering if anyone could help me, i have a list of people, and payments. for example : <colgroup><col><col></colgroup><tbody> Eddie 10 Steve 12 Steve 65 Steve 12 Steve 12 Steve 35 Steve 56 James 66 James 73 James 21 James 33 James 21 James 21 James...

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
Back
Top