transactions

on the AND page starting around 6:30 of the youtube video for Total COGS ($), Count Transactions, and Average Cost ($) when I put in the sumif, averagif, and countif formulas it is only giving me the answers for the 2 transaction that are true. Its not including the total sum of all the false...

I am creating a pivot from a database of 7500 transactions spanning 13 months. The row labels are GL account #s . The column labels are Year/Month. I am getting GL #s listed twice. I have tried reformatting cells in the database, making all transactions left-justified, and copying/pasting...

Hi All, I have a question that I can't figure without adding additional columns to the data to match missing descriptions. I have a short list with cost and descriptions to apply to a larger list with codes that relate to the descriptions, yet the descriptions are not present in the larger list...

Hi, I have a database which captures quite a bit of data, among them financial transactions. At the beginning of each month a number of reports are generated for the previous month's transactions, most of which are exported to Excel and works perfectly. We have now been given an annual...

Hi all, I need to get how many transactions occur over a three month period for example but I only need Saturday's and Sunday's (about 35000 lines/transactions). I tried to filter the info in a power pivot but the date filter won't let me do specific days. I've managed to get dates and a...

Good afternoon, This is a beginner's post: how do I modify "= Odbc.Query("dsn=QuickBooks Data", "select timemodified#(lf)from creditmemoline")" to pull all columns from this table (creditmemoline) for only transactions posted from 1/1/2016 through 6/30/2017? Thank you for your consideration, Sally

Hi Experts, Heres my query and thank you in advance for your help. TABLE 1 === I have a list of sales transactions. <tbody> Date Item # Revenue Cost Profit 17 feb 2017 568 $100 $70 30 18 Feb 2017 439 $120 $130 -10 01 Mar 2017 439 $150 $130 20 </tbody> TABLE 2 === I have another table...

I have an excel sheet with 24K rows of monetary transactions. Each transaction is given a category; There are 6 different categories. I stored the transactions into an array. I want to sum each category and store them (category and total amount) into another array. How would I go about...

Hi I have a spreadsheet with each column representing a day of the month starting with the 28th which is payday. Down the left are all the income and outgoing that are predictable and repeating. In row 46 I have my Predicted balance ie what it would be if the income and expenditure occurred...

I have a large dataset of transactions that I want to organize by type of transactions. The only way to know what type of transactions they are is to keyword filter them in a column of transaction descriptions. The descriptions are not uniformly coded and oftentimes, you will not find the...

I'm trying to find a workaround for the fact that Quickbooks does not have a suitable solution for printing donation receipts that comply with Canada's CRA guidelines. We are not actually using Quickbooks yet, but we need a more formal system, and this seems to be the preferred option, with the...

Hi guys I have a set of data, pulled from Google Analytics in the following format: Transaction ID | Product Name 1 | milk 1 | bread 2 | jam 3 | bread 3 | honey I need to transform this data...

SET UP: I've created a user form where a person can enter information such as the date, explanation of transaction, amount, recurrence pattern (weekly, bi-weekly, or monthly), and number of recurrences. That information is then transferred to the worksheet, changing the date by the...

Hello Friends Could you please help me with the following: I am trying to create a form for sale invoice. I am not sure how to deduct quantity from the warehouse stock table when invoice is saved/printed. Similarly I want to increment inventory every time receiving ticket is saved/printed. I...

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 -...