Hi there guys, I am trying to figure it out how to properly set manager in my work environment, so id like to get suggestions from people who use the same apps: Square and Paypal Currently, In my business, I use Square to collect payments and PayPal to buy parts/supplies (non-inventory items). To do my accounting i just imported the bank statements into manager and categorized the transactions as needed (includes CC, Square and Paypal) but i know this is not the right way as i am ommiting Square merchandise Fee and basically, i just reporting a chunch deposit amounts. My goal is to" 1- Import the scheduled square deposits into manager and be able to record the Square Fee on it, which is 2.75 perecent + 30c, so far when i generated the deposit csv report from square, manager is not able to retrieve the Fee value and i dont know why as i have tried different avenues like changing header columns title but no luck. see screenshot when imported. [Selection_208] [Selection_209] 2- As for PayPal, i use it mainly to buy online, i don’t sell with it, so there is no PayPal Fee involved, however, I am confused. In manager I created a Paypal account and imported the monthly statements from it into manager, however since i dont keep any money on PayPal, for every transaction I make with paypal, it first transfers the money from my bank into PayPal to cover the purchase, as you can see in the screenshot below, the problem is how to reflect this in manager? Once the transactions are imported how to reflect the transfer from my Bank into Paypal for every transaction made? [Selection_207] Thanks in advanced for the help.

How should Manager handle this ideally? One idea I have is that it could import each CSV line as 2 separate transactions (one for gross amount, another one for the fee). This would allow to use simple receipt and payment rules to quickly categorize them.

I already told you I have no experience with Square.

square is just another CC Merchandise, we use to collect CC Payments, nothing special about it. Every CC Merchandise company will give you that report.

What is special about Square is its specific fee structure and the way it reports transactions. Every credit card processor is unique in that way. There is no standard.

is the same as paypal as it also has Fees.

That does not mean their statement formats are the same.

[image] shootify: the issue is I cant import the FEE (comission they get per transaction), See Trouble Importing Bank Statement (accounting for ebay fee) - #10 by lubos

HI @Patch , where is this screenshot from, when i create a new rule i dont have the option for percentage, in fact , looks way different that the screenshot below. [Selection_945]

Looks like a receipt bank rule. I didn’t generate it & I agree showing the bread crumbs in screenshots is preferable for precisely this reason.

hi @Patch this is what i have on my end. [Selection_946]

The post where @Patch copied that illustration is more than 9 years old. There is a high probability whatever it is and wherever it is from have changed.

Need some help with square and paypal workflow

Uncategorized

Patch December 1, 2023, 4:37am 13

See Trouble Importing Bank Statement (accounting for ebay fee) - #10 by lubos

Topic		Replies	Views
PayPal Fees Uncategorized	17	3246	July 24, 2017
How to properly import stripe transactions into manager Uncategorized	3	393	January 28, 2024
Not importing the "Fee" column on CSV file Uncategorized	4	312	July 11, 2023
Importing PayPal/Zettle transactions? Uncategorized	4	324	April 23, 2024
PayPal fees and transaction charges Uncategorized	10	4371	January 31, 2016

Need some help with square and paypal workflow

Related topics