How to Import Store transactions
Watch Video
- Import transactions individually
- Bulk import transactions to the same budget category
- Bulk Delete transactions from a bank register
Import transactions individually
Click Banking in the sidebar.
Click the Actions dropdown to the right of the Store Clearing Account.
Choose Import Transactions from the dropdown.
Select the date range then click Fetch transactions to import.
Click the Import as button next to the items you’d like to import.
Withdrawals and deposits can be imported by choosing Transaction from the dropdown.
Check that all fields are filled correctly and assign a category. The store fees category will auto-populate as a split with a negative amount.
Click Save & Close. This will take you back to the Transactions Available to Import screen.
To hide a transaction so that it doesn’t get imported, click the “eye” icon.
Bulk import transactions to the same budget category
In the import screen after transactions have been fetched, toggle Bulk Import on.
Select the transactions to be imported into the same budget category.
Click Bulk Import.
Choose a Budget Category from the dropdown.
To change the Reference and/or Paid To information to something other than what was brought in from the Store account, toggle either or both on and enter the information. Changing these fields will change it for all of the selected transactions.
Check that all of the information is correct. Click Import. This will import all of the selected transactions at once.
When funds are transferred from the Store in Cheddar Up to your bank account, this can be imported as a transfer or the transfer can be entered manually.
Click Banking in the sidebar
Click the Actions dropdown to the right of the Store Clearing account.
Choose New Transfer from the dropdown.
The From bank account should be the Store Clearing account. The To bank account should be the account the money was deposited into, i.e. checking account.
Fill in the details and click Save.
Note: If you have bank integration, deposits from Cheddar Up can be imported as transfers rather than manually recorded.
Bulk Delete transactions from a bank register
To bulk delete transactions, navigate to the bank register and toggle on Bulk Delete.
Select the transactions to be deleted. (Note: only transactions that are not reconciled can be deleted)
Click Delete selected transactions at the bottom of the page.
Note: After being deleted, imported transactions will reappear on the import page, where they can be reimported or hidden.
Connect your Venmo account to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Connect your Stripe Account to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Set up a MoneyMinder Store free. Just pay 0.4% /transaction*
Connect your Bank, Square and PayPal accounts to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Connect your Bank, Paypal and Square accounts to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Connect your Bank, Paypal and Square accounts to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Join It is a membership management service that helps businesses and nonprofits effectively sell, track, and grow their membership.
If we take a cash payment in the cheddar up app, it imports but says “Transaction handled outside of Cheddar Up”. I can understand why I can’t import the cash transaction but is there a way to hide it or otherwise address it, so it doesn’t keep coming up as a transaction available to import?
Hi Sandra,
Yes, you can hide those transactions in the import screen by clicking the “eye” symbol to the left of the import button.
Is there a way to mass import transactions into one category? For instance we run a store for a fundraiser, and within that fundraiser the purchaser can purchase multiple items from different item types. When it is time to import the transactions we have to manually go through each sale and then manually assign the category for each item purchased. This is time consuming. Is there an easier, less time consuming way to do this?
Hi Jennifer,
There are a couple of things you could consider in this situation.
First, if you make your budget category names in MoneyMinder the same as the item names in your Cheddar Up store, the budget categories will auto-full when importing. You will still import each transaction individually, but the budget category will auto-fill which can save time.
The second thing you might consider is if you don’t need to track the details of each item, but only want to track the amount you make on the fundraiser, you can decide NOT to import each transaction from your Cheddar Up Store. Instead, you can just record the deposit in your bank account when you move the money from Cheddar Up and apply the whole deposit to the fundraiser category. This way it will all be applied to the fundraising category in one deposit instead of many individual transactions.
Which option you choose will depend on how much detail you would like to capture.